Well, doing on all tables at once woule probably bring the server to its knees
due to the cartesian product producing a VERY large temporary table. You can
do it on two tables at once like this (if my memory serves):
SELECT * from mytable as t1, mytable as t2
WHERE t1.column1 = t2.column1 AND
Thanks for the response, Joshua.
I am so very new to MySQL, that I am afraid I require more guidance.
Is there a way to join ALL tables in a database rather than just one table
to itself, or one particular table to another?
SELECT * FROM allTables WHERE column1=column1 AND column2=column2 AND
co
Yes, there is a way. It's called joins. :) I don't remember the exact syntax
off the top of my head, but the approach is thus:
Do a self join on the table and select records that match in their first three
columns, but do not have the same primary key (you *do* have primary keys on
your table
