Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations IamaSherpa on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
Join where second table has duplicate values
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 -
Join where second table has duplicate values
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...
