Add to Chrome
✅ The verified answer to this question is available below. Our community-reviewed solutions help you understand the material better.
Cum obții clienții care NU au plasat nicio comandă (tabel Clienti, tabel Comenzi cu ID_Client ca FK)?
Clienti
Comenzi
ID_Client
SELECT * FROM Clienti WHERE ID NOT IN (SELECT ID_Client FROM Comenzi);
SELECT * FROM Clienti WHERE ID IN (SELECT ID_Client FROM Comenzi);
SELECT * FROM Clienti JOIN Comenzi ON Clienti.ID = Comenzi.ID_Client;
Get Unlimited Answers To Exam Questions - Install Crowdly Extension Now!