Question

Locked

sql query

By moni30 ·
Hi All,

I want to display records form Table1 but only those records form Table1 must not be present in table 2

This conversation is currently closed to new comments.

2 total posts (Page 1 of 1)  
| Thread display: Collapse - | Expand +

All Answers

Collapse -

not a well-formulated desire

by john.a.wills In reply to sql query

Still, what about this?
SELECT x, y, z, key
FROM table1
WHERE NOT EXISTS (SELECT *
FROM table2
WHERE table2.key = table1.key)

Back to Web Development Forum
2 total posts (Page 1 of 1)  

Software Forums