Hi all,
I am running the following query from MS-SQL 2012
Code:
select CI.cust_id,COD.FirstOrderDate,COD.LastOrderDate
from
[LINKEDSERVER].[database].[schema].[custinfo] CI,
(
SELECT cohead_cust_id,MIN(cohead_orderdate) as FirstOrderDate , MAX(cohead_orderdate) as LastOrderDate
FROM [LINKEDSERVER].[database].[schema].cohead AS cohead
GROUP BY cohead_cust_id
) COD
WHERE CI.cust_id = COD.cohead_cust_id
This returns the error
OLE DB provider "PGNP" for linked server "OPENMFG-PROD" returned message "Undefined column name "Expr1004"".
An error occurred while preparing the query "SELECT "Tbl1001"."cust_id" "Col1026","Expr1004","Expr1005" FROM [snip]
Now if I run the inner query by itself, no error returns.
Notice the two Min Max functions in the inner query. The problems seems to lie here. If I do not include the two dates in the outer select, the query runs fine.
So the Min(date) and Max(date) seem to cause problems ONLY in a JOIN.
Anyone have any idea what is going on here?
Thank you
Bob
