Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

JOINS

Status
Not open for further replies.

TomBarrand

Programmer
Joined
Aug 9, 2000
Messages
162
Location
GB
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
 
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

 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top