Here is another option [UNTESTED]: select `pseudoA`.`x` Ax, `pseudoA`.`y` Ay, `pseudoA`.`z` Az, `pseudoB`.`x` Bx, `pseudoB`.`y` By, `pseudoB`.`z` Bz FROM `tableA` pseudoA, `tableB` pseudoB WHERE `pseudoA`.`ID` = `pseudoB`.`ID` .
2008/11/3 Michael <[EMAIL PROTECTED]> > > 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? > > > > -- Nicolaas Thiemen Francken Director - Sunny Side Up Ltd skype: nicolaasthiemen within NZ phone 0800 771 777 overseas call +64 274 771 777 [EMAIL PROTECTED] http://www.sunnysideup.co.nz - client login: http://www.rakau.com/ - new quotes: http://www.sunnysideup.co.nz/services - please support: http://www.localorganics.net/ - newsletter: http://www.sunnysideup.co.nz/contact --~--~---------~--~----~------------~-------~--~----~ NZ PHP Users Group: http://groups.google.com/group/nzphpug To post, send email to [email protected] To unsubscribe, send email to [EMAIL PROTECTED] -~----------~----~----~----~------~----~------~--~---
