[AccessD] Missing Issues Query

On 8/17/07, Gary Kjos <garykjos at gmail.com> wrote:
> Well what you are after is a left join kind of a query from the table
> that has all the magazines go the table that has the missing ones with
> the join option to say "give me all the records" in the table with all
> the magazines. Then you do a condition on one of the table fields in
> the other table to test for "IS Null" and you will only get the ones
> that are missing.

Maybe I'm missing what you are saying Gary, but I've only got 1 table,
and that is the table with the issues of the magazine that I have. I
don't have table with a full list of potential issues.

-- 
Bryan Carbonnell - carbonnb at gmail.com
Life's journey is not to arrive at the grave safely in a well
preserved body, but rather to skid in sideways, totally worn out,
shouting "What a great ride!"