Page 1 of 1

combined select

Posted: Tue Feb 17, 2004 9:33 am
by pelegk2
i want to make a select like this :
in the first tablr a regular select

select * from mydb
but in this select i want that the produc_id which has a full name in another table will be taken when the select is done!

the point is:
i have 2 tables :
the first which i make a selct on
and the second 1 which had the full name for the product _id from the first table!
how can i make a select that for each product_id will give me the fukk name too?
thanks in advance
peleg

Posted: Tue Feb 17, 2004 9:52 am
by McGruff