bender007
asked on
Count(*) from multiple tables
How do i pull a count(*) from 6 tables. Each has a Account ID that should be matched.
Account ID table1 table2 table3 table3 ...
-------------------------- ---------- ---------- ---
0001 10 21 7 8
0004 .................
Account ID table1 table2 table3 table3 ...
--------------------------
0001 10 21 7 8
0004 .................
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Ok its an alias, I got that , why start from Table2 ?
>>why start from Table2 ?<<
Look again. I started with Table1.
Look again. I started with Table1.
ASKER