I am writing in reference to a previous post. I am trying to combine two tables that do not have a common column name but do share two columns with SOME common data.
I will explain in this example: Table A- AcctID, Table B- PartnerID, AcctValue
The column I am truly interested in is AcctValue which is in table B. I want to find the AcctValue for each AcctID. The problem is Partner does not match ALL AcctID only small portion.
There are 4,000 AcctID and they only match up with 2,000 PartnerID so I am not able to find the AcctValue for 2,000 AcctID.
This is what I've done but only shows me 2,000 AcctID:
How can I get all the AcctId and their AcctValues? I am sure there is a way to do this but I can seem to figure it out
asked Jul 28, 2011 at 08:21 AM in Default
If there is no column that reliably corresponds to AcctID then there is no way to reliably associate an AcctValue with an AcctID.
answered Jul 28, 2011 at 08:24 AM