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 Rhinorhino on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Recent content by f1team
-
Combining records
I have a database table tblobjects like this: object_name, reference_id a 1 a 2 a 3 a 4 b 2 b 3 b 1 b 4 c 2 c 4 c 5 c 6 d 2 d 4 d 5 d 6 I now would like to have a SQL query which gives me the number of unique object and reference combinations, like this: a b c d shouldn't be displayed...
