You mean UNION? SELECT x,y,z FROM table_one WHERE id='$id' UNION SELECT x,y,z FROM table_two WHERE id='$id'
On Mon, Nov 3, 2008 at 10:16 PM, Michael <[EMAIL PROTECTED]> wrote: > > 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? > > > > -- Visit my website: http://onlinesid.com --~--~---------~--~----~------------~-------~--~----~ NZ PHP Users Group: http://groups.google.com/group/nzphpug To post, send email to [email protected] To unsubscribe, send email to [EMAIL PROTECTED] -~----------~----~----~----~------~----~------~--~---
