more than one column equi-join, how??

[hengsin]

tblPart = Part_Num,Business_Unit_Id

tblOrderDetail = Part_num,Business_Unit_Id

tblCorp = Business_Unit_Id

I have three tables as stated above. I want to equi-join tblPart.Part_Num = tblOrderDetail.Part_Num and tblPart.Business_Unit_Id = tblOrderDetail.Business_UnitId and tblOrderDetail.Business_Unit_id = tblCorp.Business_Unit_id

I don;t know how to contruct this kind of join in SQL for Oracle 7. I'm using SQL Plus 3.3.

If there is only one-column join but i'm having difficult to contruct for more than one column.

Thanks

 

[sem]

You may explicitly specify as many join conditions as you need. Oracle 7 doesn't support JOIN syntax, so you should write them in WHERE clause:

select * from tblPart
,tblOrderDetail
,tblCorp
where tblPart.Part_Num = tblOrderDetail.Part_Num and tblPart.Business_Unit_Id = tblOrderDetail.Business_UnitId and tblOrderDetail.Business_Unit_id = tblCorp.Business_Unit_id


Regards, Dima