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: ...
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
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