W
Will G
can anyone see what i am not see...the sql bellow give me a syntax error on
join operation, but i dont see where. is it because there are too many joins?
SELECT MSM.ModelNumber, MSM.Desc1, MSM.Desc2, Spring.Spring, Label.Label,
Size.Size, Needle.Needle, Pattern.Pattern, Config.Config, Border.Border,
MSM.Produce, Concatenate("SELECT Qfill FROM qrQfills WHERE ModelNumber = """
& [MSM].[ModelNumber] & """") AS Qfill, Concatenate("SELECT Bfill FROM
qrBfill WHERE ModelNumber = """ & [MSM].[ModelNumber] & """") AS Bfill,
Concatenate("SELECT UphFill FROM qrUphfills WHERE ModelNumber = """ &
[MSM].[ModelNumber] & """") AS Uphfill, Concatenate("SELECT PtFill FROM
qrPtfills WHERE ModelNumber =""" & [MSM].[ModelNumber] & """") AS Ptfill,
FoamCore.FoamCore, FoamEnc.FoamEnc
FROM [Size] INNER JOIN (Pattern INNER JOIN (Needle INNER JOIN (Label INNER
JOIN (Config INNER JOIN (Border INNER JOIN (FoamCore INNER JOIN(FoamEnc INNER
JOIN(Spring INNER JOIN MSM ON Spring.SpringID = MSM.SpringID) ON
Border.BorderID = MSM.BorderID) ON Config.ConfigID = MSM.ConfigID) ON
Label.LabelID = MSM.LabelID) ON Needle.NeedleID = MSM.NeedleID) ON
Pattern.PatternID = MSM.PatternID) ON Size.SizeID = MSM.SizeID)ON
FoamCore.FoamCoreID = FoamCoreID)ON FoamEnc.FoamEncID = MSM.FoamEncID;
join operation, but i dont see where. is it because there are too many joins?
SELECT MSM.ModelNumber, MSM.Desc1, MSM.Desc2, Spring.Spring, Label.Label,
Size.Size, Needle.Needle, Pattern.Pattern, Config.Config, Border.Border,
MSM.Produce, Concatenate("SELECT Qfill FROM qrQfills WHERE ModelNumber = """
& [MSM].[ModelNumber] & """") AS Qfill, Concatenate("SELECT Bfill FROM
qrBfill WHERE ModelNumber = """ & [MSM].[ModelNumber] & """") AS Bfill,
Concatenate("SELECT UphFill FROM qrUphfills WHERE ModelNumber = """ &
[MSM].[ModelNumber] & """") AS Uphfill, Concatenate("SELECT PtFill FROM
qrPtfills WHERE ModelNumber =""" & [MSM].[ModelNumber] & """") AS Ptfill,
FoamCore.FoamCore, FoamEnc.FoamEnc
FROM [Size] INNER JOIN (Pattern INNER JOIN (Needle INNER JOIN (Label INNER
JOIN (Config INNER JOIN (Border INNER JOIN (FoamCore INNER JOIN(FoamEnc INNER
JOIN(Spring INNER JOIN MSM ON Spring.SpringID = MSM.SpringID) ON
Border.BorderID = MSM.BorderID) ON Config.ConfigID = MSM.ConfigID) ON
Label.LabelID = MSM.LabelID) ON Needle.NeedleID = MSM.NeedleID) ON
Pattern.PatternID = MSM.PatternID) ON Size.SizeID = MSM.SizeID)ON
FoamCore.FoamCoreID = FoamCoreID)ON FoamEnc.FoamEncID = MSM.FoamEncID;