Choosing Records From One Table Depending On Criteria In A Different Table

[JakeMogul]

I'm making a page which shows from a table only items that are cheapest from a certain supplier using <.

 

The problem I'm encountering is that the prices are stored in a different table, a master price list.

 

I have a query SELECT * FROM tablename WHERE column1 < column 2

 

but the WHERE part of the clause needs to apply to a different table than the table I'm selecting records from.

[Barand]

Then you need to JOIN that table to the other one

 

http://www.phpfreaks.com/tutorial/data-joins-unions