Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> 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