1-- b.VALUE1 is null when ID not in table22-- LEFT OUTER JOIN is equivalent to LEFT JOIN3SELECT a.ID, a.NAME, b.VALUE1 FROM1 table1 a
4LEFTOUTERJOIN table2 b
5ON a.ID = b.ID
6WHERE a.ID >=1000;
7-- ⇓ Test it ⇓ (Fiddle source link)
you will get a confirmation link on this - you will have to click that for successful submission of your answer. we require this to keep the website free of spam, bots and unhelpful content
please ensure to add code which is syntactically corrent and executes properly
you will get a confirmation link on this - you will have to click that for successful submission of your question. we require this to keep the website free of spam, bots and unhelpful content