SQL Statement Error

[Anonymous]

Hello all,

I am trying to add a SQL query into our data source. While adding the query, I am getting the below error:

Following is the query where I have the ON within my statement:

From Quote.dbo.ABC a

Left Join (

                Select [MURAEA],

                [H40CEA] as H40CEA,

                [GA02EA]

                    FROM [ASTRO].[dbo].[SMEAP00]

) b

on a.GPN=b.[MURAEA]

Left Join (

               SELECT

               [QUOTDD] as Quote_Num,

               [MURADD] as GPN,

               [CQTYDD]

FROM [QUOTE].[dbo].[MEADDP00]

Where [CYMDDD]>'20180101'

)

on a.GPN=c.GPN

-- and a.Quote=c.[QUOTDD]

Please let me know if anyone knows where I am doing wrong. All help will be appreciated.

Regards!

[dixitmca · Accepted solution]

Hi,

You have left aliasing as C to third sub query 

you should write:-

Left Join (

               SELECT

               [QUOTDD] as Quote_Num,

               [MURADD] as GPN,

               [CQTYDD]

FROM [QUOTE].[dbo].[MEADDP00]

Where [CYMDDD]>'20180101'

) c

on a.GPN=c.GPN