Sir how to solve ques no 6 of SQL quiz IP 8.4

#1

sir how to solve ques no 6 of SQL quiz IP 8.4

#2

Hi Aayush,

Using left join, it will be
select ProductId, PDesc from Product1 p left join Sales1 s on p.ProductID = s.ProductID where s.SN is null

Another one will be
select * from Prodduct1 where ProductID not in (select distinct ProductID from Sales1);

#3

Hey Aayush,
As you are not responding to this thread, I am marking your doubt as Resolved for now. Re-open it if required.

Please mark your doubts as resolved in your course’s “ Ask Doubt ” section, when your doubt is resolved.