Forum Discussion
SQL Statement Error
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!
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
1 Reply
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