Hi Hi I want to query multiple tables and think I need a little help
Using this example I have 2 tables Table1 Table Name: one Field: Surname Field: Setnumber Table2 Table Name: two Field: Surname Field: Setnumber Using: SELECT COUNT(*) AS res, FROM one, two where one.surname like ('"& globsurname & "') or two.surname like ('"& globsurname & "') Works fine, However I want to group the results by set number so did this: SELECT COUNT(*) AS res, setnumber FROM one, two where one.surname like ('"& globsurname & "') or two.surname like ('"& globsurname & "') group by setnumber It fails with 'setnumber' in field list is ambiguous Simplistically I want to search x number of tables for a surname (all the tables have a surname column and a setnumber column ) and on the first pass return how many searched names it found per set. The user will then be able to focus on a set if required. Regards John Berman [EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]