JOINS

[TomBarrand]

I am using the following join.

Select Size.Size_No, Size.Purch_Ord_Line_No, Size.Size_A, Size.Size_B, Size.SKU, FOB_Size.Ratio, FOB_Size.Size_Quantity
FROM Size LEFT OUTER JOIN FOB_Size
ON Size.Size_No = FOB_Size.Size_No

I also need to join another table with the following clause:

FROM FOB LEFT OUTER JOIN FOB_Size
ONFOB.FOB_No = FOB_Size.FOB_No

How do I do this?

Cheers

 

[stigejg]

What kind of BDMS do you have?

Because I can't find anything wrong with your select-sentence.

But if you uses Oracle and SQL* plus you have to use an other syntax, like this:

Select Size.Size_No, Size.Purch_Ord_Line_No, Size.Size_A, Size.Size_B, Size.SKU, FOB_Size.Ratio, FOB_Size.Size_Quantity
FROM Size, FOB_Size
WHERE Size.Size_No (+)= FOB_Size.Size_No;

Regard Stig