combined select

[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

[AstroTeg]

Inner joins will be your friend:

SELECT * FROM mydb INNER JOIN anotherdb ON anotherdb.product id = mydb.product id

The inner join sets up a relationship between the two tables. With this query, it will find all relationships. You could use the where clause to narrow the query down. You may find a left join handy as well (maybe you have a product but it doesn't have a full name - the inner join will not show that product but a left join would - depends on how your data is setup and how you are using it).