JOIN on composite primary key (mysql)

[meghatronic]

I have two tables:

db_refs_link
prints_id, id*, db*

and

db_refs
id*, db*, desc

*Composite primary key.

I'd like to join these two tables on the composite primary key.

1) SELECT * FROM `db_refs` JOIN `db_refs_link` ON `db_refs`.id= `db_refs_link`.id

2) SELECT DISTINCT * FROM `db_refs` JOIN `db_refs_link` ON `db_refs`.id= `db_refs_link`.id AND `db_refs`.db= `db_refs_link`.db

2) doesn't work and 1) yields too many (and wrong) results.

Any ideas?

 

[Dfhaii]

SELECT * FROM db_refs AS a, db_refs_link AS b WHERE a.id = b.id;


Would something like that not do what you want?

 

[meghatronic]

SELECT * FROM db_refs AS a, db_refs_link AS b WHERE a.id = b.id;

Would something like that not do what you want?

Nope, yields the same as 1.

 

[meghatronic]

I've sorted it. I can not believe the problem - so silly I won't tell