Query in Sql Server

Question

i have two table .Table1 and Table 2 i want to data of Table 1 .Which shaded Red . What will be query

Supreeth J · Answer

Hi, SELECT * FROM TABLEA A WHERE NOT EXISTS (SELECT * FROM TABLEB WHERE ID = A.ID) SELECT DISTINCT ID FROM A WHERE ID NOT IN (SELECT ID FROM B); SELECT DISTINCT A.ID FROM A LEFT OUTER JOIN B ON A.ID = B.ID WHERE B.ID IS NULL SELECT * FROM A WHERE ID NOT IN ( SELECT DISTINCT ID FROM B ) GROUP BY ID HAVING COUNT(*) > 1; https://www.simple-talk.com/sql/performance/the-except-and-intersect-operators-in-sql-server/

Abhishek Singh · Answer

Please try this , ;WITH userCTE(ID,NAME) AS ( select t1.ID,t1.Name from table_1 t1 inner join Table_2 t2 on t1.id=t2.userid ) select * from Table_1 where id not in (select distinct ID from userCTE) Hope this will help. Abhishek

Partha Sarathi · Answer

Hi if u used primary key and forigen key u can use inner left joins refer this query SELECT Orders.OrderID, Customers.CustomerName, Orders.OrderDate FROM Orders INNER JOIN Customers ON Orders.CustomerID=Customers.CustomerID; or simply u can type select * from tabel1

Query in Sql Server

Answers (3)