Re: Pls correct SQL. Urgent

Użytkownik KK napisał:

> Hi
>
> There is no cahnge in the results even after removing +.
>
> outer join + is because the query has to return b.call_status as blank
> if it doesn't have any record in table b with p_transid.
>

It's pure cartezian product. Without DISTINCT you achive 64 records, each record from first table joined with each record from the second.

Try to add:
a.call_time = b.call_time(+)

-- 
TomekB tbal_at_spam_go2_trap.pl GSM:Era 698093109
{Peugeot 306 ST, WY - 49245,       GG: 947-891}