aeris130 Posted March 7, 2006 Share Posted March 7, 2006 Is it possible to select data from several tables usingGET * FROM [more then one table] WHERE etc...? Quote Link to comment Share on other sites More sharing options...
shocker-z Posted March 7, 2006 Share Posted March 7, 2006 yes it is.. you will use thinks like this:SELECT table1.id, table1.name, table2.product, table3.price FROM table1, table2, table3and simular things like there but you will usualy have to reference table fields with the tablename.tablefield Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.