MySQL Lists are EOL. Please join:

List:General Discussion« Previous MessageNext Message »
From:Tewfic Kidess Date:August 16 2002 2:31pm
Subject:select from two different tables query
View as plain text  

I have two different tables with similar fields (id, name, profession,
hobbies) Some people might be listed in both tables.  I need a write query
to select
count(*) from the tables group by name... i'd like it get something like

Joe Smith..... total 5 records ..... 3 records from table 1 ........ 2
records from table 2

Any help will be greatly appreciated.
select from two different tables queryTewfic Kidess16 Aug