Gary Stainburn <[EMAIL PROTECTED]> writes:
> So, who does this select not return the row?
> select v_d_code, v_o_number, v_vin, v_status from vista_details where v_vin
> not in (
> goole(# select substring(w_vin from '(.{11}$)') from walon);
NOT IN with a sub-select that returns any NULL valu
I folks.
I'm struggling with a select which should be easy.
select v_d_code, v_o_number, v_vin, v_status from vista_details where
v_d_code='64340' and v_o_number='C0023';
v_d_code | v_o_number |v_vin| v_status
--++-+-
64340| C0023
