Join where second table has duplicate values

[mrlw00r]

Hi, I'm trying to join two tables, where the second table contains one column only. This second column contains duplicates of the primary key in the first table - I'm trying to get all records which are common to both, but not the duplicates... is there a simple answer and I'm just being daft?

cheers
Mike

 

[fluteplr]

select * from table1
where exists (select * from table2 where table1.key = table2.key)

 

[mrlw00r]

Ahhh, sadly I'm using MySQL and exists hasn't been implemented yet!
And I've just answered my own problem... I should have used
select DISTINCT * from .............
Doh... Thanks 4 the reply though!!!

Mike

 

[Cagliostro]

see MySQL forum. John Fill

ivfmd@mail.md

 

[fluteplr]

If you are using a totally non ansii compliant database like SQL please have the courtesy to mention this in your post or as Johnfill said post to the appropriate forum.