select record from temporary table ??

Question

hii friends i have a first temporary table in which some column like : client id client name details and another second table : city in which have column clientid city name and want select both table with inner join first table it have 200 record and both tables some client id same i want select those record from first table that client id it not have in second table i want remaining client details which client id not common in second table

Bikesh Srivastava · Answer

Hi Please use query like this... SELECT T1.* FROM T1 WHERE NOT EXISTS( SELECT NULL FROM T2 WHERE T1.ID = T2.ID AND T1. Date = T2. Date ) mark as answer if solve query..

Manas Mohapatra · Answer

Use LEFT OUTER JOIN: SELECT * FROM table1 LEFT JOIN table2 ON table1.ClientID = table2.ClientID WHERE table2.City IS NULL Or you can use EXCEPT in SQLServer SELECT ID NAME AMOUNT DATE FROM CUSTOMERS LEFT JOIN ORDERS ON CUSTOMERS.ID = ORDERS.CUSTOMER_ID EXCEPT SELECT ID NAME AMOUNT DATE FROM CUSTOMERS RIGHT JOIN ORDERS ON CUSTOMERS.ID = ORDERS.CUSTOMER_ID; https://www.tutorialspoint.com/sql/sql-except-clause.htm