By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
432,247 Members | 871 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 432,247 IT Pros & Developers. It's quick & easy.

Some data missing from 2 table query.

P: 72
Hi all,

I am attmepting to run a query based on 2 tables.

In the query there are 3 fields from table 1 and 2 fields from table 2.

The common field in both is Change.ID

The query is working however there is about 70% of the data missing from the 2 fields in table 2

I have checked and the data missing is definitely there if I check manually in table 2.

I have tried the 3 different joins available, and only join that works is number 3 (include all records from table 1 and only those records from table 2 where the joined fields are equal.

The SQL is as below

SELECT Table1.Approver_Group, Table1.Approval_Status, Table1.Change_ID, Table2.Brief_Change_Details
FROM Table2 RIGHT JOIN Table1 ON Table2.Change_ID = Table1.Change_ID
WHERE (((Table1.Approver_Group) Like "example"))
ORDER BY Table1.Change_ID DESC
WITH OWNERACCESS OPTION;


I have searched for days, but cannot solve this one.

Thanks in advance.
Gareth
Mar 5 '11 #1
Share this Question
Share on Google+
1 Reply


P: 72
This one is resolved. I managed to solve this one by creating static tables from the ODBC link. Using Append and make table queries it is now working.
Apr 30 '11 #2

Post your reply

Sign in to post your reply or Sign up for a free account.