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

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

P: n/a
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

Jul 18 '07 #1
Share this Question
Share on Google+
3 Replies


P: n/a
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

Jul 18 '07 #2

P: n/a
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
Jul 19 '07 #3

P: n/a
On Jul 18, 9:17 pm, John Winterbottom <john...@rogers.cawrote:
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

Jul 19 '07 #4

This discussion thread is closed

Replies have been disabled for this discussion.