Re: another mental block - Help still wanted Pleeeeease!!!

> >
> > But what I need is
> >
> >
> > N_ID V_ V_T V_VAL
> > --------- -- --- ---------
> > 1111 AV TLL 150
> > 2222 AV TLP 100
> > 3333 AV TQD 100
> > 4444 AV 100
> > 5555 AJ RDL 120
> > 6666 AJ RPX 200
> > 7777 AJ RPN 125
> >
> > Any help/suggestions gratefully received (I'm getting desperate)
> >
> > CE
>
> Try the following:
>
> select n.n_id,
> n.v_cat,
> n.v_type,
> v.v_val
> from tclnvv n,
> tclval v
> where n.v_cat = v.v_cat
> and n.v_type = v.v_type
> union all
> select n.n_id,
> n.v_cat,
> n.v_type,
> v.v_val
> from tclnvv n,
> tclval v
> where n.v_cat = v.v_cat(+)
> and v.v_type is null
> order by 1
> /

Thanks, but unfortunately that gets me ...

     N_ID V_ V_T V_VAL
--------- -- --- ---------

     1111 AV TLL       150
     1111 AV TLL       100 <- Don't want this
     2222 AV TLP       100
     3333 AV TQD       100
     4444 AV           100
     5555 AJ RDL       120 
     5555 AJ RDL       200 <- Don't want this
     6666 AJ RPX       200
     7777 AJ RPN       125
     7777 AJ RPN       200 <- Don't want this

10 rows selected. Received on Thu Nov 06 2003 - 03:18:26 CST