I have some code but it moans that CDPOS is a Clustered or Pooled table so I can not link. Is there a way to do this or ?
My Code is
SQL SELECT CDHDR~OBJECTCLAS CDHDR~OBJECTID CDHDR~CHANGENR CDHDR~UDATE PCDPOS~CHANGENR PCDPOS~VALUE_NEW
FROM CDHDR JOIN PCDPOS
ON CDHDR~CHANGENR = PCDPOS~CHANGENR
WHERE (CDHDR~OBJECTCLAS = 'MATERIAL') AND (CDHDR~UDATE >= '20131101');
/QTQVC/OPEN_STREAM failed after 00:00:00 Key = SQL_ERROR (ID:00 Type:E Number:001 For pooled tables, cluster tables and projection views, JOIN is not allowed: "PCDPOS".)
WHERE (CDHDR~OBJECTCLAS = 'MATERIAL') AND (CDHDR~UDATE >= '20131101')