Jump to content

Comparing data in 3 separate tables


mgmiller81
 Share

Recommended Posts

I have 3 tables where there is data taken from a master and 2 other sources (all should be in the master, and the other two tables are independent). The first two columns are the same (contract and amount) and the third column is where the data comes from. I am quite new to sql and have been trying to eliminate rows that have the same contract and amount, but print all three columns. I tried union, but did not work because of the third column and then tried a couple of = and != where statements, but am not getting any closer, any help would be greatly appreciated.

Link to comment
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
 Share

×
×
  • Create New...