473,387 Members | 1,785 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,387 software developers and data experts.

Select from a Table the entries that are different from another table

Dear all,


how can I select from a table only those entries that do not exist in a different table?

I have a database of clients and just received an excel sheet with new clients. so i created a table for the New Clients and wanted to check which of them do not already exist in the Old Clients table. How should I do that - I tried many times with all SQL commands I knew. Thank you!

Anca
Jan 11 '07 #1
3 1312
ADezii
8,834 Expert 8TB
Dear all,


how can I select from a table only those entries that do not exist in a different table?

I have a database of clients and just received an excel sheet with new clients. so i created a table for the New Clients and wanted to check which of them do not already exist in the Old Clients table. How should I do that - I tried many times with all SQL commands I knew. Thank you!

Anca
Select Query, New, Unmatched Query Wizard, and follow the prompts. This Wizard is fairly straightforward.
Jan 11 '07 #2
NeoPa
32,556 Expert Mod 16PB
FYI The way it works is that it links to the other table with a LEFT JOIN and only shows records where the linked to table's fields are Null. This is the case when there is no match found.

Your best way of producing this is to follow ADezii's instructions.
Jan 12 '07 #3
Thank you so, so much!!! I never used the Unmatched Query wizzard before... I owe you big time! Thanks! :D
Jan 12 '07 #4

Sign in to post your reply or Sign up for a free account.

Similar topics

3
by: Benjamin Dickgießer | last post by:
Hi, I want to create a sql query but don't know if this is possible with mysql. The Query should do the following: Select all db entries from table in which entry a is smaller than the number...
5
by: callmebill | last post by:
I'm relatively new to javascript, and I'm trying to decide whether the following (and if so, clues on how to do it): I'd like to create two HTML multiple-select boxes. The first would be a list...
3
by: Kall, Bruce A. | last post by:
I've look for a solution to this, but have only been able to find solutions to delete duplicate entries in a table by deleting entries not returned by SELECT DISTINCT. What sql should I use to...
21
by: Johan Tibell | last post by:
I would be grateful if someone had a minute or two to review my hash table implementation. It's not yet commented but hopefully it's short and idiomatic enough to be readable. Some of the code...
2
by: unabogie | last post by:
I have a table with entries tied to a membership database. The problem is that I want to select a limit of sixteen entries per member, per day, where some members have 16+ entries per day. I...
4
by: Deus402 | last post by:
I am designing an employer database, and I had thought that my tabledesign was pretty sound, but a new revelation has ruined my design. What I guess i really need is a way to uniquely identify...
11
by: Richard Maher | last post by:
Hi, I have read many of the copius entries on the subject of IE performance (or the lack thereof) when populating Select Lists. I don't mind the insert performance so much, (I get 100x120byte...
9
by: P3Eddie | last post by:
Hello all! I don't know if this can even be done, but I'm sure you will either help or suggest another avenue to accomplish the same. My problem may be a simple find duplicates / do something...
7
by: beary | last post by:
I'll try to explain the problem, but it may not make sense. I have a mysql table with columns like id,title,speaker,day,month,year, topic etc. At present, my syntax is select * from files order...
0
by: Charles Arthur | last post by:
How do i turn on java script on a villaon, callus and itel keypad mobile phone
0
by: aa123db | last post by:
Variable and constants Use var or let for variables and const fror constants. Var foo ='bar'; Let foo ='bar';const baz ='bar'; Functions function $name$ ($parameters$) { } ...
0
by: ryjfgjl | last post by:
If we have dozens or hundreds of excel to import into the database, if we use the excel import function provided by database editors such as navicat, it will be extremely tedious and time-consuming...
0
by: ryjfgjl | last post by:
In our work, we often receive Excel tables with data in the same format. If we want to analyze these data, it can be difficult to analyze them because the data is spread across multiple Excel files...
0
by: emmanuelkatto | last post by:
Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud. Please let me know. Thanks! Emmanuel
0
BarryA
by: BarryA | last post by:
What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...
1
by: nemocccc | last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
0
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...
0
jinu1996
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...

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.