Row precision vs. Aggregation errors: MAP is the best way to use "greedy" functions like AND or OR in a single, dynamic ...

SELECT * FROM `the_table` WHERE `field1` LIKE 'string%' OR `field2` LIKE 'string%' OR `field3` LIKE 'string%' OR `field4` LIKE 'string%' OR `field5` LIKE 'string%' OR `field6` LIKE 'string%' OR ...

I want to join tables based on more than one column. Is this possible? What is the syntax to do it?<BR><BR>For example, here is a join using one column:<BR><BR>SELECT au_fname, au_lname, title<BR>FROM ...