A
Amy Schmid
I am trying to get my query to run but it is giving me an error about SQL.
"The SQL statemtent could not be executed because it contains ambiguous
outer joins. To force one of hte joins to be performed first, create a
separate query that performs the first join and then inlude that in your SQL
statement."
I have no idea what the SQL statement is and how to do what the message is
asking.
Here is the SQL View on my query:
SELECT dbo_Clients.Cltnum, dbo_Clients.Cltname,
dbo_ajs_Ag_FS_Section.FSSection, dbo_ajs_Ag_FS_Detail.FSDetailName,
dbo_ajs_Ag_FS_Data.FSYear, dbo_ajs_Ag_FS_Data.FSAmount,
dbo_ajs_Ag_NFS_Data.NFSYear, dbo_ajs_Ag_NFS_Data.[DCQtr12-31PY],
dbo_ajs_Ag_NFS_Data.[DCQtr3-31], dbo_ajs_Ag_NFS_Data.[DCQtr3-31],
dbo_ajs_Ag_NFS_Data.[DCQtr6-30], dbo_ajs_Ag_NFS_Data.[DCQtr9-30],
dbo_ajs_Ag_NFS_Data.[DCQtr12-31], dbo_ajs_Ag_NFS_Data.[MCQtr12-31PY],
dbo_ajs_Ag_NFS_Data.[MCQtr3-31], dbo_ajs_Ag_NFS_Data.[MCQtr6-30],
dbo_ajs_Ag_NFS_Data.[MCQtr9-30], dbo_ajs_Ag_NFS_Data.[MCQtr12-31],
dbo_ajs_Ag_NFS_Data.CWTMilk, dbo_ajs_Ag_NFS_Data.OwnHrs,
dbo_ajs_Ag_NFS_Data.EmpHrs, dbo_ajs_Ag_NFS_Data.MlkPr
FROM (dbo_ajs_Ag_FS_Section LEFT JOIN (dbo_ajs_Ag_FS_Data RIGHT JOIN
dbo_ajs_Ag_FS_Detail ON dbo_ajs_Ag_FS_Data.FSDetailName =
dbo_ajs_Ag_FS_Detail.FSDetailName) ON dbo_ajs_Ag_FS_Section.FSSection =
dbo_ajs_Ag_FS_Detail.FSSection) LEFT JOIN ((dbo_ajs_Ag_NFS_MilkPrice LEFT
JOIN dbo_ajs_Ag_NFS_Data ON dbo_ajs_Ag_NFS_MilkPrice.MilkPriceID =
dbo_ajs_Ag_NFS_Data.MlkPr) LEFT JOIN dbo_Clients ON
dbo_ajs_Ag_NFS_Data.Cltnum = dbo_Clients.Cltnum) ON dbo_ajs_Ag_FS_Data.Cltnum
= dbo_ajs_Ag_NFS_Data.Cltnum;
I am using Access 2000.
Thanks in advance!
"The SQL statemtent could not be executed because it contains ambiguous
outer joins. To force one of hte joins to be performed first, create a
separate query that performs the first join and then inlude that in your SQL
statement."
I have no idea what the SQL statement is and how to do what the message is
asking.
Here is the SQL View on my query:
SELECT dbo_Clients.Cltnum, dbo_Clients.Cltname,
dbo_ajs_Ag_FS_Section.FSSection, dbo_ajs_Ag_FS_Detail.FSDetailName,
dbo_ajs_Ag_FS_Data.FSYear, dbo_ajs_Ag_FS_Data.FSAmount,
dbo_ajs_Ag_NFS_Data.NFSYear, dbo_ajs_Ag_NFS_Data.[DCQtr12-31PY],
dbo_ajs_Ag_NFS_Data.[DCQtr3-31], dbo_ajs_Ag_NFS_Data.[DCQtr3-31],
dbo_ajs_Ag_NFS_Data.[DCQtr6-30], dbo_ajs_Ag_NFS_Data.[DCQtr9-30],
dbo_ajs_Ag_NFS_Data.[DCQtr12-31], dbo_ajs_Ag_NFS_Data.[MCQtr12-31PY],
dbo_ajs_Ag_NFS_Data.[MCQtr3-31], dbo_ajs_Ag_NFS_Data.[MCQtr6-30],
dbo_ajs_Ag_NFS_Data.[MCQtr9-30], dbo_ajs_Ag_NFS_Data.[MCQtr12-31],
dbo_ajs_Ag_NFS_Data.CWTMilk, dbo_ajs_Ag_NFS_Data.OwnHrs,
dbo_ajs_Ag_NFS_Data.EmpHrs, dbo_ajs_Ag_NFS_Data.MlkPr
FROM (dbo_ajs_Ag_FS_Section LEFT JOIN (dbo_ajs_Ag_FS_Data RIGHT JOIN
dbo_ajs_Ag_FS_Detail ON dbo_ajs_Ag_FS_Data.FSDetailName =
dbo_ajs_Ag_FS_Detail.FSDetailName) ON dbo_ajs_Ag_FS_Section.FSSection =
dbo_ajs_Ag_FS_Detail.FSSection) LEFT JOIN ((dbo_ajs_Ag_NFS_MilkPrice LEFT
JOIN dbo_ajs_Ag_NFS_Data ON dbo_ajs_Ag_NFS_MilkPrice.MilkPriceID =
dbo_ajs_Ag_NFS_Data.MlkPr) LEFT JOIN dbo_Clients ON
dbo_ajs_Ag_NFS_Data.Cltnum = dbo_Clients.Cltnum) ON dbo_ajs_Ag_FS_Data.Cltnum
= dbo_ajs_Ag_NFS_Data.Cltnum;
I am using Access 2000.
Thanks in advance!