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

Need query to return rows that don't match

P: n/a
I have two tables each with one column of serial numbers. I need a query
that will return only the serial numbers from Table1 that aren't in
Table2. I need it to also return the serial numbers from Table2 that
aren't in Table1.

Is there an easy way to do this? So far I haven't found a way...

*** Sent via Developersdex http://www.developersdex.com ***
May 10 '07 #1
Share this Question
Share on Google+
2 Replies


P: n/a
Hi,
Use the Query wizard to create an 'Unmatched' query
bobh.

On May 10, 3:39 pm, Terry Olsen <tolse...@hotmail.comwrote:
I have two tables each with one column of serial numbers. I need a query
that will return only the serial numbers from Table1 that aren't in
Table2. I need it to also return the serial numbers from Table2 that
aren't in Table1.

Is there an easy way to do this? So far I haven't found a way...

*** Sent via Developersdexhttp://www.developersdex.com***

May 10 '07 #2

P: n/a
Go Queries at the database window. Click on new. Select the unmatched
records wizard and follow the directions to get the queries you want.

PC Datasheet
Providing Customers A Resource For Help With Access, Excel And Word
Applications
"Terry Olsen" <to******@hotmail.comwrote in message
news:46*********************@news.qwest.net...
>I have two tables each with one column of serial numbers. I need a query
that will return only the serial numbers from Table1 that aren't in
Table2. I need it to also return the serial numbers from Table2 that
aren't in Table1.

Is there an easy way to do this? So far I haven't found a way...

*** Sent via Developersdex http://www.developersdex.com ***

May 10 '07 #3

This discussion thread is closed

Replies have been disabled for this discussion.