Jump to content


Photo

Selecting several tables


  • Please log in to reply
1 reply to this topic

#1 aeris130

aeris130
  • Members
  • PipPip
  • Member
  • 22 posts

Posted 07 March 2006 - 07:52 AM

Is it possible to select data from several tables using

GET * FROM [more then one table] WHERE etc...

?

#2 shocker-z

shocker-z
  • Members
  • PipPipPip
  • Advanced Member
  • 864 posts
  • LocationNottingham

Posted 07 March 2006 - 10:00 AM

yes it is.. you will use thinks like this:

SELECT table1.id, table1.name, table2.product, table3.price FROM table1, table2, table3


and simular things like there but you will usualy have to reference table fields with the tablename.tablefield
www: www.ukchat.ws | irc: irc.ukchat.ws chan: #blufudge




0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users