Is this what your teacher wanted???Code:SELECT t1.c1, t1.c2, t1.c3, NVL(t2.c4, 'null') c4 FROM t1 LEFT OUTER JOIN t2 ON t1.c1 = t2.c1 AND t1.c2 = t2.c2;![]()
|
Results 1 to 4 of 4
Thread: Select statement helpThreaded View
|
Click Here to Expand Forum to Full Width |