Tuesday, 20 August 2013

LEFT JOIN (SELECT) Syntax Error In From Clause

LEFT JOIN (SELECT) Syntax Error In From Clause

Can some one point out to me the error in this sql statement?
SELECT CommTypes.Description
FROM CommTypes
LEFT JOIN
(
SELECT *
FROM IntroducerBasis
WHERE IntroducerBasis.IntroducerCode='AG'
AND IntroducerBasis.BasisNumber=1
) AS Intro
ON CommTypes.ID = Intro.CommTypeID;
The error highlights the subsequent SELECT statement as the source of the
error.

No comments:

Post a Comment