I have a table that I select from as follows SELECT x,y,z FROM table WHERE id='$id'
I want to break this into 2 tables where 'id' is the 'primary' field and is identical on both tables. How can I SELECT the same x,y,z now from the 2 tables using 1 SQL statement? --~--~---------~--~----~------------~-------~--~----~ NZ PHP Users Group: http://groups.google.com/group/nzphpug To post, send email to nzphpug@googlegroups.com To unsubscribe, send email to [EMAIL PROTECTED] -~----------~----~----~----~------~----~------~--~---