JCTDD
asked on
4 tables, show the IDs in each table on one row
I have 4 tables with 3 common fields
4 tables:
1. WASP
2. REGIONALS
3. SCCM
4. ACCOUNTS
3 common fields in all tables:
1. Asset
2. Office
3. Owner
I need a SQL query to compare the 4 tables and list the 3 common fields
each row should have one asset value e.g.
4 tables:
1. WASP
2. REGIONALS
3. SCCM
4. ACCOUNTS
3 common fields in all tables:
1. Asset
2. Office
3. Owner
I need a SQL query to compare the 4 tables and list the 3 common fields
each row should have one asset value e.g.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.