That would work if Michael wanted to find results which appeared in *both* tables.
I think he wanted to find matching results in *either* table, though. On Thu, Jan 8, 2009 at 6:05 AM, nancy .. <[email protected]> wrote: > please check this one also > SELECT * FROM test1,test2 where test1.blah=test2.blah --~--~---------~--~----~------------~-------~--~----~ NZ PHP Users Group: http://groups.google.com/group/nzphpug To post, send email to [email protected] To unsubscribe, send email to [email protected] -~----------~----~----~----~------~----~------~--~---
