What is an SQL Query for showing the details of one table that another doesn’t have.

[AakashData]

What is an SQL Query for showing the details of one table that another doesn’t have.

[ChrisNZ]

Have you looked at SQL's EXCEPT operator?

[Reeza]

---

@AakashData wrote:

What is an SQL Query for showing the details of one table that another doesn’t have.

---

In terms of rows or in terms of different variable names? Vague questions will get you vague answers, please take the time to detail your questions.

[sandeep12]

 The query that can be used is:

SELECT * FROM Worker
MINUS
SELECT * FROM Title;

[ChrisNZ]

@sandeep12 

The MINUS operator is only used by a few databases.

SAS uses the ANSI-standard EXCEPT operator.