Размер видео: 1280 X 720853 X 480640 X 360
Показать панель управления
Автовоспроизведение
Автоповтор
4:27 WHY NOT JUST USE JOIN?select * from FirstTable as t1left join SecondTable as t2 on t1.ID=t2.ID;
Hi. That is a good start, but that will show all rows in t1 (and where they exist in t2). However, I want to find all of those which are in t1 but not in t2. Phillip
4:27 WHY NOT JUST USE JOIN?
select * from FirstTable as t1
left join SecondTable as t2
on t1.ID=t2.ID
;
Hi. That is a good start, but that will show all rows in t1 (and where they exist in t2). However, I want to find all of those which are in t1 but not in t2. Phillip