Queries --> Finding what is not in table 2 from the data in table 1

[boston_dude]

So if I were to take table 1 and relate it to table 2 (one-to-one), I
could then run a query which would display the records that are in
both tables.

I'm looking to run a query that would display the records in table 2
that are not in table 1. What is the easiest/best way to do this?

Thanks,

Ian

[John]

Does this help?
http://www.fabalou.com/access/Queries/isnullquery.asp
john

"boston_dude" <ia********@gmail.comschreef in bericht
news:11**********************@e16g2000pri.googlegr oups.com...

So if I were to take table 1 and relate it to table 2 (one-to-one), I
could then run a query which would display the records that are in
both tables.

I'm looking to run a query that would display the records in table 2
that are not in table 1. What is the easiest/best way to do this?

Thanks,

Ian

[John Winterbottom]

select * from foo
where not exists
(
select * from bar
where bar.id = foo.id
)

boston_dude wrote:

So if I were to take table 1 and relate it to table 2 (one-to-one), I
could then run a query which would display the records that are in
both tables.

I'm looking to run a query that would display the records in table 2
that are not in table 1. What is the easiest/best way to do this?

Thanks,

Ian

[boston_dude]

On Jul 18, 9:17 pm, John Winterbottom <[e-mail]:

select * from foo
where not exists
(
select * from bar
where bar.id = foo.id
)

boston_dude wrote:

So if I were to take table 1 and relate it to table 2 (one-to-one), I
could then run a query which would display the records that are in
both tables.

I'm looking to run a query that would display the records in table 2
that are not in table 1. What is the easiest/best way to do this?

Thanks,

Ian- Hide quoted text -

- Show quoted text -

Awesome. Thank you both, very much.

Cheers!

Ian