Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: How to do the SELECT?
Hello!
AK пишет в сообщении <38194BC5.BB30D845_at_sqli.fr> ...
>I thinks that it works :
01 AA 01 TEST 02 YY 02 TEST1
You should try
SELECT t1.col1, NVL(t2.col, 'none')
FROM temp t1, temp1 t2
WHERE t1.col1=t2.col1(+)
HTH Rgds, Vadim Grepan