nht_cntt

Câu 18 Phần III QLBH

Oct 24th, 2015
316
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
SQL 0.20 KB | None | 0 0
  1. SELECT SOHD FROM HOADON WHERE NOT EXISTS
  2. (
  3.     SELECT * FROM SANPHAM WHERE NUOCSX = 'Singapore' AND NOT EXISTS
  4.     (
  5.         SELECT * FROM CTHD WHERE CTHD.SOHD = HOADON.SOHD AND CTHD.MASP = SANPHAM.MASP
  6.     )
  7. )
Advertisement
Add Comment
Please, Sign In to add comment