Syntax error in from clause

M

MikeC

I just broke one of my queries and can't seem to remember how I got it
working when I originally created it.

I'm using incorrect syntax, so I'm getting the "Syntax error in from clause"
error message.

I believe I need to somehow tell the Jet 4 SQL engine that all of the text
following the first FROM clause is the data source for the query. Can
someone tell me how to do that?

I've already tried parethesis() and square brackets[], but neither has
worked.


SELECT * INTO tblLBONT91
FROM SELECT
Database
, ProjectCode
, ProjectName
, ProjectStatus
, Category
, ProjClass
, Department
, MainProject
, Sum(ActHours) AS SumActHours
, Sum(ActProjRev) AS SumActProjRev
, Sum(ActProjCost) AS SumActProjCost
, Sum(AdjToDate) AS SumAdjToDate
, Sum(BilToDate) AS SumBilToDate
, Sum(BilUnbilled) As SumBilUnbilled
FROM [qryLBONT91-GetALLData-FCGMS2]
GROUP BY
Database
, ProjectCode
, ProjectName
, ProjectStatus
, Category
, ProjClass
, Department
, MainProject

UNION ALL

SELECT
Database
, ProjectCode
, ProjectName
, ProjectStatus
, Category
, ProjClass
, Department
, MainProject
, Sum(ActHours) AS SumActHours
, Sum(ActProjRev) AS SumActProjRev
, Sum(ActProjCost) AS SumActProjCost
, Sum(AdjToDate) AS SumAdjToDate
, Sum(BilToDate) AS SumBilToDate
, Sum(BilUnbilled) As SumBilUnbilled
FROM [qryLBONT91-GetALLData-GERMANY2]
GROUP BY
Database
, ProjectCode
, ProjectName
, ProjectStatus
, Category
, ProjClass
, Department
, MainProject

UNION ALL

SELECT
Database
, ProjectCode
, ProjectName
, ProjectStatus
, Category
, ProjClass
, Department
, MainProject
, Sum(ActHours) AS SumActHours
, Sum(ActProjRev) AS SumActProjRev
, Sum(ActProjCost) AS SumActProjCost
, Sum(AdjToDate) AS SumAdjToDate
, Sum(BilToDate) AS SumBilToDate
, Sum(BilUnbilled) As SumBilUnbilled
FROM [qryLBONT91-GetALLData-UK2]
GROUP BY
Database
, ProjectCode
, ProjectName
, ProjectStatus
, Category
, ProjClass
, Department
, MainProject

UNION ALL SELECT
Database
, ProjectCode
, ProjectName
, ProjectStatus
, Category
, ProjClass
, Department
, MainProject
, Sum(ActHours) AS SumActHours
, Sum(ActProjRev) AS SumActProjRev
, Sum(ActProjCost) AS SumActProjCost
, Sum(AdjToDate) AS SumAdjToDate
, Sum(BilToDate) AS SumBilToDate
, Sum(BilUnbilled) As SumBilUnbilled
FROM [qryLBONT91-GetALLData-USA2]
GROUP BY
Database
, ProjectCode
, ProjectName
, ProjectStatus
, Category
, ProjClass
, Department
, MainProject
ORDER BY ProjectCode, Category;
 
D

Dale Fye

Mike,

Try the following.

SELECT T.*
INTO tblLBONT91
FROM

(SELECT
Database
, ProjectCode
, ProjectName
, ProjectStatus
, Category
, ProjClass
, Department
, MainProject
, Sum(ActHours) AS SumActHours
, Sum(ActProjRev) AS SumActProjRev
, Sum(ActProjCost) AS SumActProjCost
, Sum(AdjToDate) AS SumAdjToDate
, Sum(BilToDate) AS SumBilToDate
, Sum(BilUnbilled) As SumBilUnbilled
FROM [qryLBONT91-GetALLData-FCGMS2]
GROUP BY
Database
, ProjectCode
, ProjectName
, ProjectStatus
, Category
, ProjClass
, Department
, MainProject

UNION ALL

SELECT
Database
, ProjectCode
, ProjectName
, ProjectStatus
, Category
, ProjClass
, Department
, MainProject
, Sum(ActHours) AS SumActHours
, Sum(ActProjRev) AS SumActProjRev
, Sum(ActProjCost) AS SumActProjCost
, Sum(AdjToDate) AS SumAdjToDate
, Sum(BilToDate) AS SumBilToDate
, Sum(BilUnbilled) As SumBilUnbilled
FROM [qryLBONT91-GetALLData-GERMANY2]
GROUP BY
Database
, ProjectCode
, ProjectName
, ProjectStatus
, Category
, ProjClass
, Department
, MainProject

UNION ALL

SELECT
Database
, ProjectCode
, ProjectName
, ProjectStatus
, Category
, ProjClass
, Department
, MainProject
, Sum(ActHours) AS SumActHours
, Sum(ActProjRev) AS SumActProjRev
, Sum(ActProjCost) AS SumActProjCost
, Sum(AdjToDate) AS SumAdjToDate
, Sum(BilToDate) AS SumBilToDate
, Sum(BilUnbilled) As SumBilUnbilled
FROM [qryLBONT91-GetALLData-UK2]
GROUP BY
Database
, ProjectCode
, ProjectName
, ProjectStatus
, Category
, ProjClass
, Department
, MainProject

UNION ALL SELECT
Database
, ProjectCode
, ProjectName
, ProjectStatus
, Category
, ProjClass
, Department
, MainProject
, Sum(ActHours) AS SumActHours
, Sum(ActProjRev) AS SumActProjRev
, Sum(ActProjCost) AS SumActProjCost
, Sum(AdjToDate) AS SumAdjToDate
, Sum(BilToDate) AS SumBilToDate
, Sum(BilUnbilled) As SumBilUnbilled
FROM [qryLBONT91-GetALLData-USA2]
GROUP BY
Database
, ProjectCode
, ProjectName
, ProjectStatus
, Category
, ProjClass
, Department
, MainProject ) as T
ORDER BY T.ProjectCode, T.Category;


MikeC said:
I just broke one of my queries and can't seem to remember how I got it
working when I originally created it.

I'm using incorrect syntax, so I'm getting the "Syntax error in from clause"
error message.

I believe I need to somehow tell the Jet 4 SQL engine that all of the text
following the first FROM clause is the data source for the query. Can
someone tell me how to do that?

I've already tried parethesis() and square brackets[], but neither has
worked.


SELECT * INTO tblLBONT91
FROM SELECT
Database
, ProjectCode
, ProjectName
, ProjectStatus
, Category
, ProjClass
, Department
, MainProject
, Sum(ActHours) AS SumActHours
, Sum(ActProjRev) AS SumActProjRev
, Sum(ActProjCost) AS SumActProjCost
, Sum(AdjToDate) AS SumAdjToDate
, Sum(BilToDate) AS SumBilToDate
, Sum(BilUnbilled) As SumBilUnbilled
FROM [qryLBONT91-GetALLData-FCGMS2]
GROUP BY
Database
, ProjectCode
, ProjectName
, ProjectStatus
, Category
, ProjClass
, Department
, MainProject

UNION ALL

SELECT
Database
, ProjectCode
, ProjectName
, ProjectStatus
, Category
, ProjClass
, Department
, MainProject
, Sum(ActHours) AS SumActHours
, Sum(ActProjRev) AS SumActProjRev
, Sum(ActProjCost) AS SumActProjCost
, Sum(AdjToDate) AS SumAdjToDate
, Sum(BilToDate) AS SumBilToDate
, Sum(BilUnbilled) As SumBilUnbilled
FROM [qryLBONT91-GetALLData-GERMANY2]
GROUP BY
Database
, ProjectCode
, ProjectName
, ProjectStatus
, Category
, ProjClass
, Department
, MainProject

UNION ALL

SELECT
Database
, ProjectCode
, ProjectName
, ProjectStatus
, Category
, ProjClass
, Department
, MainProject
, Sum(ActHours) AS SumActHours
, Sum(ActProjRev) AS SumActProjRev
, Sum(ActProjCost) AS SumActProjCost
, Sum(AdjToDate) AS SumAdjToDate
, Sum(BilToDate) AS SumBilToDate
, Sum(BilUnbilled) As SumBilUnbilled
FROM [qryLBONT91-GetALLData-UK2]
GROUP BY
Database
, ProjectCode
, ProjectName
, ProjectStatus
, Category
, ProjClass
, Department
, MainProject

UNION ALL SELECT
Database
, ProjectCode
, ProjectName
, ProjectStatus
, Category
, ProjClass
, Department
, MainProject
, Sum(ActHours) AS SumActHours
, Sum(ActProjRev) AS SumActProjRev
, Sum(ActProjCost) AS SumActProjCost
, Sum(AdjToDate) AS SumAdjToDate
, Sum(BilToDate) AS SumBilToDate
, Sum(BilUnbilled) As SumBilUnbilled
FROM [qryLBONT91-GetALLData-USA2]
GROUP BY
Database
, ProjectCode
, ProjectName
, ProjectStatus
, Category
, ProjClass
, Department
, MainProject
ORDER BY ProjectCode, Category;
Click to expand...
 
M

MikeC

Perfect. That did it. Thanks a lot.

Dale Fye said:
Mike,

Try the following.

SELECT T.*
INTO tblLBONT91
FROM

(SELECT
Database
, ProjectCode
, ProjectName
, ProjectStatus
, Category
, ProjClass
, Department
, MainProject
, Sum(ActHours) AS SumActHours
, Sum(ActProjRev) AS SumActProjRev
, Sum(ActProjCost) AS SumActProjCost
, Sum(AdjToDate) AS SumAdjToDate
, Sum(BilToDate) AS SumBilToDate
, Sum(BilUnbilled) As SumBilUnbilled
FROM [qryLBONT91-GetALLData-FCGMS2]
GROUP BY
Database
, ProjectCode
, ProjectName
, ProjectStatus
, Category
, ProjClass
, Department
, MainProject

UNION ALL

SELECT
Database
, ProjectCode
, ProjectName
, ProjectStatus
, Category
, ProjClass
, Department
, MainProject
, Sum(ActHours) AS SumActHours
, Sum(ActProjRev) AS SumActProjRev
, Sum(ActProjCost) AS SumActProjCost
, Sum(AdjToDate) AS SumAdjToDate
, Sum(BilToDate) AS SumBilToDate
, Sum(BilUnbilled) As SumBilUnbilled
FROM [qryLBONT91-GetALLData-GERMANY2]
GROUP BY
Database
, ProjectCode
, ProjectName
, ProjectStatus
, Category
, ProjClass
, Department
, MainProject

UNION ALL

SELECT
Database
, ProjectCode
, ProjectName
, ProjectStatus
, Category
, ProjClass
, Department
, MainProject
, Sum(ActHours) AS SumActHours
, Sum(ActProjRev) AS SumActProjRev
, Sum(ActProjCost) AS SumActProjCost
, Sum(AdjToDate) AS SumAdjToDate
, Sum(BilToDate) AS SumBilToDate
, Sum(BilUnbilled) As SumBilUnbilled
FROM [qryLBONT91-GetALLData-UK2]
GROUP BY
Database
, ProjectCode
, ProjectName
, ProjectStatus
, Category
, ProjClass
, Department
, MainProject

UNION ALL SELECT
Database
, ProjectCode
, ProjectName
, ProjectStatus
, Category
, ProjClass
, Department
, MainProject
, Sum(ActHours) AS SumActHours
, Sum(ActProjRev) AS SumActProjRev
, Sum(ActProjCost) AS SumActProjCost
, Sum(AdjToDate) AS SumAdjToDate
, Sum(BilToDate) AS SumBilToDate
, Sum(BilUnbilled) As SumBilUnbilled
FROM [qryLBONT91-GetALLData-USA2]
GROUP BY
Database
, ProjectCode
, ProjectName
, ProjectStatus
, Category
, ProjClass
, Department
, MainProject ) as T
ORDER BY T.ProjectCode, T.Category;


MikeC said:
I just broke one of my queries and can't seem to remember how I got it
working when I originally created it.

I'm using incorrect syntax, so I'm getting the "Syntax error in from clause"
error message.

I believe I need to somehow tell the Jet 4 SQL engine that all of the
text
following the first FROM clause is the data source for the query. Can
someone tell me how to do that?

I've already tried parethesis() and square brackets[], but neither has
worked.


SELECT * INTO tblLBONT91
FROM SELECT
Database
, ProjectCode
, ProjectName
, ProjectStatus
, Category
, ProjClass
, Department
, MainProject
, Sum(ActHours) AS SumActHours
, Sum(ActProjRev) AS SumActProjRev
, Sum(ActProjCost) AS SumActProjCost
, Sum(AdjToDate) AS SumAdjToDate
, Sum(BilToDate) AS SumBilToDate
, Sum(BilUnbilled) As SumBilUnbilled
FROM [qryLBONT91-GetALLData-FCGMS2]
GROUP BY
Database
, ProjectCode
, ProjectName
, ProjectStatus
, Category
, ProjClass
, Department
, MainProject

UNION ALL

SELECT
Database
, ProjectCode
, ProjectName
, ProjectStatus
, Category
, ProjClass
, Department
, MainProject
, Sum(ActHours) AS SumActHours
, Sum(ActProjRev) AS SumActProjRev
, Sum(ActProjCost) AS SumActProjCost
, Sum(AdjToDate) AS SumAdjToDate
, Sum(BilToDate) AS SumBilToDate
, Sum(BilUnbilled) As SumBilUnbilled
FROM [qryLBONT91-GetALLData-GERMANY2]
GROUP BY
Database
, ProjectCode
, ProjectName
, ProjectStatus
, Category
, ProjClass
, Department
, MainProject

UNION ALL

SELECT
Database
, ProjectCode
, ProjectName
, ProjectStatus
, Category
, ProjClass
, Department
, MainProject
, Sum(ActHours) AS SumActHours
, Sum(ActProjRev) AS SumActProjRev
, Sum(ActProjCost) AS SumActProjCost
, Sum(AdjToDate) AS SumAdjToDate
, Sum(BilToDate) AS SumBilToDate
, Sum(BilUnbilled) As SumBilUnbilled
FROM [qryLBONT91-GetALLData-UK2]
GROUP BY
Database
, ProjectCode
, ProjectName
, ProjectStatus
, Category
, ProjClass
, Department
, MainProject

UNION ALL SELECT
Database
, ProjectCode
, ProjectName
, ProjectStatus
, Category
, ProjClass
, Department
, MainProject
, Sum(ActHours) AS SumActHours
, Sum(ActProjRev) AS SumActProjRev
, Sum(ActProjCost) AS SumActProjCost
, Sum(AdjToDate) AS SumAdjToDate
, Sum(BilToDate) AS SumBilToDate
, Sum(BilUnbilled) As SumBilUnbilled
FROM [qryLBONT91-GetALLData-USA2]
GROUP BY
Database
, ProjectCode
, ProjectName
, ProjectStatus
, Category
, ProjClass
, Department
, MainProject
ORDER BY ProjectCode, Category;
Click to expand...
Click to expand...
 
Top