Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: Sql to PL/Sql sub-query

Re: Sql to PL/Sql sub-query

From: Rauf Sarwar <rs_arwar_at_hotmail.com>
Date: 16 Jun 2003 22:12:04 -0700
Message-ID: <92eeeff0.0306162112.77c7e2a1@posting.google.com>


mchristy433_at_yahoo.com (MChristy) wrote in message news:<53143d38.0306160613.56765189_at_posting.google.com>...
> I have two questions based on the Sql statement below:
>
> 1 SELECT TRMJC.LERETA19589.PARCEL,TRMJC.LERETA19589.PROPID,mpropertynumber
> 2 FROM trmjc.lereta19589 LEFT JOIN
> 3 (SELECT sa.t_property.mpropertynumber,sa.t_property.mpropertyid
> 4 FROM sa.t_property
> 5 WHERE sa.t_property.mendtaxyear= 999999999
> 6 and sa.t_property.meffstatus = 'A')
>
> 7 ON trmjc.lereta19589.parcel=mpropertynumber
> 8 WHERE mpropertynumber IS NULL
>
> 1.) Why on line 7 when I preface the field mpropertynumber with the
> table owner and the table i.e. sa.t_property.mpropertynumber I receive
> the following error (Invalid Column Name)? Otherwise, if I do not do
> this the SQL statement works fine.
>
> 2.)How would you convert the above SQl syntax to PL/SQL syntax i.e.
> using the operator (+) to accomplish the left join.
>
> I'am new to SQl and I'am currently using PL/SQL Developer to write and
> execute my code.
>
> Thanks,
>
> Mchristy

Untested,

3 (SELECT sa.t_property.mpropertynumber AS col1,sa.t_property.mpropertyid 6 and sa.t_property.meffstatus = 'A') t1 7 ON trmjc.lereta19589.parcel=t1.col1

Regards
/Rauf Sarwar Received on Tue Jun 17 2003 - 00:12:04 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US