heyday2004
asked on
Query to find out records with duplicate of two columns combination
Query to find out records with duplicate of two columns combination
I have two tables that have the same structure but different data. Table names are a and b and column names to be used are c1, c2 (there are many other columns for table a or b)
Example:
select c1, c2 from a
c1 c2
2 UK
3 USA
5 Japan
select c1, c2 from b:
c1 c2
2 UK
3 USA
5 France
After the query, result should be (retrieve c1, c2 info from table a)
c1 c2
2 UK
3 USA
Again, note: I need to compare combined fields of c1 + c2
Thanks for any samples
I have two tables that have the same structure but different data. Table names are a and b and column names to be used are c1, c2 (there are many other columns for table a or b)
Example:
select c1, c2 from a
c1 c2
2 UK
3 USA
5 Japan
select c1, c2 from b:
c1 c2
2 UK
3 USA
5 France
After the query, result should be (retrieve c1, c2 info from table a)
c1 c2
2 UK
3 USA
Again, note: I need to compare combined fields of c1 + c2
Thanks for any samples
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
https://www.experts-exchange.com/questions/28383750/Query-to-find-out-records-with-non-duplicate-of-two-columns-combination.html
Thanks.