Query a table based on a value from another table

[protoactive]

Greetings:

I've been at this for a while now with no results.

What is the proper php syntax to query a table based on a value from another table?

For example, I have one table called "Featured" which contains a numeric value, "product_id". I need to take that value and run a query in table "Products" to get the values out.

Thanks.
Anything would help alot.

[tomhath]

You don't need two queries:

select f.somecolumn, p.othercolumns
from Featured f
inner join Products p
on f.product_id = p.product_id
where f.product_id =  1

[protoactive]

Originally posted by tomhath
You don't need two queries:

select f.somecolumn, p.othercolumns
from Featured f
inner join Products p
on f.product_id = p.product_id
where f.product_id =  1

[/B]

hmmmm....

im totally confused with this snippet. Why is f.product_id=1? Also, what is the significance of the "f." and "p."?

Thanks.

[tomhath]

Why is f.product_id=1?

No significance, just an example. Make the WHERE clause whatever it takes to select the row(s) you want.

Also, what is the significance of the "f." and "p."

Those are aliases, because I'm too lazy to type out the full table name everytime.