combined select

Questions about the MySQL, PostgreSQL, and most other databases, as well as using it with PHP can be asked here.

Moderator: General Moderators

Post Reply
User avatar
pelegk2
Forum Regular
Posts: 633
Joined: Thu Nov 27, 2003 5:02 am
Location: Israel - the best place to live in after heaven
Contact:

combined select

Post 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
McGruff
DevNet Master
Posts: 2893
Joined: Thu Jan 30, 2003 8:26 pm
Location: Glasgow, Scotland

Post by McGruff »

Post Reply