Hi Karl,
I'm not sure what I'm doing wrong, but I'm still getting no results. Maybe
I'm not explaining it well? On the parent table (Fund Table), there are
several thousand rows, each with a unique IM Number/IM Fund combination. The
Client Fund Table stores several thousand rows, identifying an IM Number/IM
Fund combination by client (but several clients have the same IM Number/IM
Fund combination). What I'm trying to find is the IM Number/IM Fund
combinations from the Fund Table that no clients have. Does that make sense?
KARL DEWEY said:
You said you were looking for no match so the fields are not null.
SELECT [Fund Table].*
FROM [Fund Table] INNER JOIN [Client Fund Table] ON ([Fund Table].[IM
Number]=[Client Fund Table].[IM Number]) AND ([Fund Table].[IM Fund]=[Client
Fund Table].[IM Fund])
WHERE ([Client Fund Table].[IM Number] <>[Fund Table].[IM Number]) Or
([Client Fund Table].[IM Fund]) <>[Fund Table].[IM Fund]);
--
KARL DEWEY
Build a little - Test a little
Chris said:
Hi Karl,
I tried the following code and my query's still producting no results... Any
thoughts?
SELECT [Fund Table].*
FROM [Fund Table] INNER JOIN [Client Fund Table] ON ([Fund Table].[IM
Number]=[Client Fund Table].[IM Number]) AND ([Fund Table].[IM Fund]=[Client
Fund Table].[IM Fund])
WHERE ((([Client Fund Table].[IM Number]) Is Null) Or (([Client Fund
Table].[IM Fund]) Is Null));
:
Try this --
SELECT [Change Requests].[Date open], [Change Requests].[Date close],
[Change Requests].x, [Change Requests].y
FROM [Change Requests] INNER JOIN [Change Requet-1] ON ([Change
Requests].[Date close] = [Change Requet-1].[Date close]) AND ([Change
Requests].[Date open] = [Change Requet-1].[Date open])
WHERE ((([Change Requests].y)<>[Change Requet-1].[y])) OR ((([Change
Requests].x)<>[Change Requet-1].[x]));
--
KARL DEWEY
Build a little - Test a little
:
Hi, I have two tables, where the child table has two primary keys to link it
to the parent table. I'm trying to create an unmatched query where it will
find any records on the parent table that don't have corresponding rows on
the child table, but I'm stuck. Does anyone have some example SQL?
Thanks,
Chris