Im SELECT mehrere Tabellen referenzieren?

[p80286]

Code:

CREATE VIEW V_SERIAL_OVERVIEW 
AS
select Pumps.PUMP_SERIAL
      ,pumps.STEP_COUNT
      ,Batches.Batches_SubID
      ,Batches.Drawing_No 
      ,Internal_Order_No.Internal_Order
from Pumps 
    ,Batches
    ,Internal_Order_No
where Pumps.Batch_ID=Batches.Batch_ID
  and Batches.Order_ID=Internal_Order_No.ID

Ich denke so sollte es gehen, ggf. so ändern:

Code:

where Pumps.Batch_ID=Batches.Batch_ID(+)
  and Batches.Order_ID=Internal_Order_No.ID(+)

(ist Oracle Syntax!)

Gruß
K-H