Fuhrmann
Well-known member
I have three databases:
- Names
name_id || gender
1 || Fuhrmann
- Product
product_id || product_name
5 || Book
6 || Phone
- ProductNames
name_id || product_id
1 || 5
1 || 6
What I'm trying to do it is get all the information (product_name, product_id, name_id, gender) in one query.
I already have wrote sql query that uses a inner join, but in the case of the ProductNames table, we have two diferentts fields. This is when it get difficult.
Any help?
- Names
name_id || gender
1 || Fuhrmann
- Product
product_id || product_name
5 || Book
6 || Phone
- ProductNames
name_id || product_id
1 || 5
1 || 6
What I'm trying to do it is get all the information (product_name, product_id, name_id, gender) in one query.
I already have wrote sql query that uses a inner join, but in the case of the ProductNames table, we have two diferentts fields. This is when it get difficult.
Any help?