Hi,
I have two tables, tableA and tableB. In tableA I have 170 names and in tableB I have more information about these names. Suppose in tableA I have fileds Name only with ID field and in tableB I have fields ID, Name, Age, Start date, End date. Both tables have Name field. What I want to do is to compare between the two tables to see what names in tableA are not yet in tableB.
Thank you very much for the support.
Abolos
3 1319
Hi,
I have two tables, tableA and tableB. In tableA I have 170 names and in tableB I have more information about these names. Suppose in tableA I have fileds Name only with ID field and in tableB I have fields ID, Name, Age, Start date, End date. Both tables have Name field. What I want to do is to compare between the two tables to see what names in tableA are not yet in tableB.
Thank you very much for the support.
Abolos
Don't post in the articles section.
Moved to the forum.
Hi,
I have two tables, tableA and tableB. In tableA I have 170 names and in tableB I have more information about these names. Suppose in tableA I have fileds Name only with ID field and in tableB I have fields ID, Name, Age, Start date, End date. Both tables have Name field. What I want to do is to compare between the two tables to see what names in tableA are not yet in tableB.
Thank you very much for the support.
Abolos
Make a query with both tables and join on name (or ID, whatever is unique). Edit the join to select All records from tableA. Show ID and name from tableA and then name from tableB and with the criteria box, select null. This will show you all ID and Names in tableA that are not in tableB
The sql below does similar, showing all Names in [tabanca] that are not in [tabanca double entry] -
SELECT Tabanca.[Tabanca ID], Tabanca.Name
-
FROM [Tabanca Double Entry] RIGHT JOIN Tabanca ON [Tabanca Double Entry].[Tabanca ID] = Tabanca.[Tabanca ID]
-
WHERE ((([Tabanca Double Entry].Name) Is Null));
-
thanks for help. I did it myself, but again thanks.
Abolos
Sign in to post your reply or Sign up for a free account.
Similar topics
by: Maur |
last post by:
Hi all,
I have 2 tables say t_OLD and t_NEW. The new has
corrections for audit purposes.
They are identical in all respects (i.e. new is a copy of
old and then changes are made to t_new)
...
|
by: Megan |
last post by:
Hi everybody-
I'm helping a friend with a music database. She has an old one and is
creating a new one. She wants to compare records and fields in the old
database with records and fields in the...
|
by: Vincent |
last post by:
has any one seen a program to compare mdbs'. I have ran into a few of
them, but none seem to really do that job.
Basically what I need to do is, take 2 access mdb's and check the
differences...
|
by: dfs9 |
last post by:
In the article "Delete Duplicate Records From Access Tables"
By Danny Lesandrini writes the following:
This final suggestion is the most flexible and accurate. Given any
table, it generates a...
|
by: VMI |
last post by:
I have two tables and I want to compare these two tables with a query( ie.
"select * from A where B.key = A.key") and the result will be stored in a
3rd table (table C). is this possible? If...
|
by: Mark |
last post by:
by m.r.davies
I have 2 tables on seperate Db's (and servers)
I want to use a datareader on the first table to pick the booking ref, and then use that booking ref to query the 2nd DB
when i have...
|
by: Shaw |
last post by:
Our database is constantly updated (input data) from another DB, and
sometimes it crashes our ASP.NET applications. My boss told me to write a DB
utility app to check DB and make sure all apps are...
|
by: Mark A |
last post by:
DB2 8.2 for Linux, FP 10 (also performs the same on DB2 8.2 for Windoes, FP
11).
Using the SAMPLE database, tables EMP and EMLOYEE.
In the followng stored procedure, 2 NULL columns (COMM) are...
|
by: Edd E |
last post by:
Hi,
I have a database to store my analyses (Access 2002, WinXp), the basic structure is:
TABLE 1 = Sample Info
TABLE 2 = Analysis type 1
TABLE 3 = Analysis type 2
TABLE 4 = Analysis type 3
...
|
by: chazzy69 |
last post by:
Ok heres what im trying to achive i am constantly updating the information in a table but know i what know if the data im replacing it with is new, i.e. whether or not i already had the data in the...
|
by: taylorcarr |
last post by:
A Canon printer is a smart device known for being advanced, efficient, and reliable. It is designed for home, office, and hybrid workspace use and can also be used for a variety of purposes. However,...
|
by: Charles Arthur |
last post by:
How do i turn on java script on a villaon, callus and itel keypad mobile phone
|
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$) {
}
...
|
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
|
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...
|
by: nemocccc |
last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
|
by: Hystou |
last post by:
There are some requirements for setting up RAID:
1. The motherboard and BIOS support RAID configuration.
2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...
|
by: Oralloy |
last post by:
Hello folks,
I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>".
The problem is that using the GNU compilers,...
|
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...
| |