vbnetcoder
asked on
sql query with union
i have a query that is working property
Select field1, field2, field3, count(8) AS countt
from master
Group By field1, field2, field3
i want to ALSO join in another table but with exactly the same fields and then return ONLY those records where count > 1
Do i do this somehow with union?
Select field1, field2, field3, count(8) AS countt
from master
Group By field1, field2, field3
i want to ALSO join in another table but with exactly the same fields and then return ONLY those records where count > 1
Do i do this somehow with union?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER