topic Re: What is an SQL Query for showing the details of one table that another doesn’t have. in SAS Programming

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

AakashData — Fri, 03 May 2019 04:38:30 GMT

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

ChrisNZ — Fri, 03 May 2019 04:55:57 GMT

Have you looked at SQL's EXCEPT operator?

Reeza — Fri, 03 May 2019 14:41:42 GMT

@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 — Sat, 04 May 2019 04:42:17 GMT

The query that can be used is:

SELECT * FROM Worker
MINUS
SELECT * FROM Title;

ChrisNZ — Mon, 06 May 2019 03:13:08 GMT

The MINUS operator is only used by a few databases.

SAS uses the ANSI-standard EXCEPT operator.