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

 

[balves]

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
LEFT OUTER JOIN FOB
ON FOB.FOB_No = FOB_Size.FOB_No