[Resolved] SELECT from 2 Tables

[rcoursey]

I have two tables related by a common field (playid.)

Additionally, I need to limit the selection to a specific record being passed by the form as $id and stored in the associated table as pickid.

So, ineed to select records from table 1 that match the $id variable to table1 pickid and I need to get information from tabl 2 by matching the t1.playid to the t2.playid. I only need two fields from table2. One is the playid and the other is title.

I hope that is clear because I don't have the foggiest idea how to go about this.

Thanks in advance

[zhabala]

You mean something like:

SELECT table2.playid, table2.title FROM table1, table2
  WHERE table1.playid = table2.playid AND table1.pickid = $id