Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Absent linked indicies?

Status
Not open for further replies.
wanttoscript

wanttoscript

IS-IT--Management
Oct 25, 2002
9
US
I have two tables with a common index.
In one table, tableA, the index is unique,
in the other, tableB, it may appear in multiple records, or in none.

How can write a query that returns the count of records in tableA that have NO linked records in tableB?

All advice will be graciously accepted.
 
Status
Not open for further replies.

Similar threads

Fish521
  • Locked
  • Question
Run Delete Query on Linked Sharepoint List
Replies
8
Views
241
Andrzejek
Andrzejek
barnettjacob
  • Locked
  • Question
Access SQL Query to get Earliest date from linked table 2
Replies
9
Views
116
PHV
PHV
1DMF
  • Locked
  • Question
ODBC - Update on Linked table 'xyz' failed?
Replies
2
Views
63
1DMF
1DMF
Dad0AEW
  • Locked
  • Question
Access 97 report using SQL Server linked tables
Replies
3
Views
41
dhookom
dhookom
abenitez77
  • Locked
  • Question
using linked sql tables in ms access
Replies
1
Views
29
dhookom
dhookom

Part and Inventory Search

Sponsor

Back
Top