473,320 Members | 1,863 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,320 software developers and data experts.

Need query to return rows that don't match

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
2 5875
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
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 thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

4
by: YoBro | last post by:
Hi, I have a database that stores in a field the number of views for a product. I want to write a query that gets the two highest views, so I can then output the result. I have this so far,...
2
by: siliconmike | last post by:
I've got a table t with rows a,b,c,d,e,f and a single index i on a,b,c,d,e,f The query is: SELECT * FROM t WHERE a="something" AND b="something" AND c="something" ORDER BY d, e, f LIMIT 100;...
4
by: jimh | last post by:
I'm not a SQL expert. I want to be able to write a stored procedure that will return 'people who bought this product also bought this...'. I have a user table that links to a transaction table...
7
by: Ion | last post by:
Hi all, I have a query that takes almost 1 hour to complete. This is acceptable in certain situations, but unacceptable when no rows should qualify. Something like: Select list >From...
0
by: DH | last post by:
Hi. I'm not a SQL power user but can handle most simple queries. But I have no idea how to approach this problem...hopefully someone can point me in the right direction. I have a table which...
1
by: David C. Barber | last post by:
I'm trying to determine if any matching records exist on a LIKE query performing a partial match of last names to a remote back-end database in the most efficient manner possible. LAN Traffic...
6
by: Chad A. Beckner | last post by:
Does anyone know how to make common database connections "common" in all aspx files? In other words, instead of creating a SQLConnection, then a DataAdapter in every ASPX file for my application,...
2
by: Keith C. Perry | last post by:
Ok, I've tried a number of things here and I know I'm missing something but at this point my head is spinning (i.e. lack of sleep, too much coffee, etc...) My environment is PG 7.4.3 on Linux...
2
by: me | last post by:
I have written a query that joins four or five tables. One table has 30,000 rows. Another table has only 200. I want to only return the 200 or so rows in the smaller table and columns from the...
0
by: DolphinDB | last post by:
The formulas of 101 quantitative trading alphas used by WorldQuant were presented in the paper 101 Formulaic Alphas. However, some formulas are complex, leading to challenges in calculation. Take...
0
by: DolphinDB | last post by:
Tired of spending countless mintues downsampling your data? Look no further! In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
0
by: Vimpel783 | last post by:
Hello! Guys, I found this code on the Internet, but I need to modify it a little. It works well, the problem is this: Data is sent from only one cell, in this case B5, but it is necessary that data...
0
by: jfyes | last post by:
As a hardware engineer, after seeing that CEIWEI recently released a new tool for Modbus RTU Over TCP/UDP filtering and monitoring, I actively went to its official website to take a look. It turned...
1
by: PapaRatzi | last post by:
Hello, I am teaching myself MS Access forms design and Visual Basic. I've created a table to capture a list of Top 30 singles and forms to capture new entries. The final step is a form (unbound)...
0
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
0
by: Defcon1945 | last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
1
by: Shællîpôpï 09 | last post by:
If u are using a keypad phone, how do u turn on JavaScript, to access features like WhatsApp, Facebook, Instagram....
0
by: Faith0G | last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.