Re: Oracle Bug? SQL not returning correct rows.

Good idea but it didn't help.

If I just try to use bill_of_lading, qty, * it gives me: "ORA-00936: missing expression".

If I try to give the table an identifier (select bill_of_lading, qty, z.* from ps_rsc_ar820_tbl z...) then it just returns an identical Z row for each of the dups. I also tried to include the identifiers in the sub-query to make sure something weird wasn't going on there and as expected Oracle complained that I was referencing an invalid identifier.

Thanks,
Ryan

>
> try query 1 and queery 3 with this select phrase:
> select bill_of_lading, qty, *
> ...
>
> and see if that doesn't give a hint at what's happening.- Hide quoted text -
>
Received on Mon Feb 12 2007 - 14:29:53 CST