Joined: Wed Dec 17, 2003 11:55 am Posts: 10
|
I am getting an outer join error please guide.
Error as shown below
outer or full join must be followed by path expression [select objectofF03 in class com.mbl.gcs.staticdata.instrument.hibernate.F03,objectofF07 in class com.mbl.gcs.staticdata.instrument.hibernate.F07 from f07 in class com.mbl.gcs.staticdata.instrument.hibernate.F07 right outer join f03 in class com.mbl.gcs.staticdata.instrument.hibernate.F03 on f03.f03PK.CMD_CODE=f07.CMD_CODE where f03.STATUS = 'O' AND f03.f03PK.MKT_CODE='FIN'
|
|