Query that only shows results on data not found in one table (1 Viewer)

Number11

Member
Local time
Today, 13:02
Joined
Jan 29, 2020
Messages
607
So i am looking for a way to have the query only show records when an order is not found in a table

is this possible
 

Minty

AWF VIP
Local time
Today, 13:02
Joined
Jul 26, 2013
Messages
10,354
Yes. Depending on your table set up.
More information required, table design and some example data would assist.
 

Uncle Gizmo

Nifty Access Guy
Staff member
Local time
Today, 13:02
Joined
Jul 9, 2003
Messages
16,244
So i am looking for a way to have the query only show records when an order is not found in a table

is this possible

Sounds like you need the "find unmatched query wizard"
 

arnelgp

..forever waiting... waiting for jellybean!
Local time
Today, 21:02
Joined
May 7, 2009
Messages
19,169
how can you show it when it cannot be found?
 

isladogs

MVP / VIP
Local time
Today, 13:02
Joined
Jan 14, 2017
Messages
18,186
This is a generic unmatched query:
Code:
SELECT column_name(s)
FROM table1
LEFT JOIN table2
ON table1.column_name = table2.column_name
WHERE table2.column_name IS NULL;

Use your own table and column names in place of those above

Or as already suggested, use the unmatched query wizard which makes this very easy to do
 

Users who are viewing this thread

Top Bottom