Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: ORA-00936: Missing Expression Error
You made an error in the outer join condition. Rewrite the outer-join as follows:
where EquipItem.EquipID = Equipment.EquipID and EquipItem.ItemID =Feature.ItemID(*)
Good luck,
Hans Steijntjes
"Arun Solleti" <asolleti_at_csee.usf.edu> schreef in bericht
news:395A586E.57B22994_at_csee.usf.edu...
> I am trying to create a view with outer join condition using the
> following code
>
> CREATE VIEW "VW_EQUIP_SEARCH1" AS select
> EQUIPITEM.ITEMID, EQUIPITEM.RETURNDT, EQUIPITEM.STATUS,
> EQUIPMENT.CATEGORY, FEATURE.DESCRIPTION
> from EQUIPITEM, EQUIPMENT, FEATURE where
> EquipItem.EquipID = Equipment.EquipID and EquipItem.ItemID =*
> Feature.ItemID;
>
> The last condition which specifies outer join is EquipItem.ItemID =*
> Feature.ItemID
>
>
> But when i use this statement it gives me an error
> ERROR at line 5:
> ORA-00936: missing expression
>
>
> Suggests are appreciated
>
> Arun
>
>
Received on Thu Jun 29 2000 - 00:00:00 CDT