Inner Join in Union Query

[RAJESHKUMAR R]

Dear Friends,



I have a Union Query Named as “ZVRR_TO_FR” which is working fine (First 2 Rows of SQL Statement).

Now, I am trying to Inner Join “Planner” Data from FG_PN_LISTS Table with reference ZVRR_TO_FR.Part_Number as reference. I am getting an Syntax Error!

Kindly Suggest me with proper SQL Statement!

SELECT Part_Number, CRD_Qty, CRD_Date, Format([CRD_Date], "MM.YYYY") AS CRD_Month, "To_Ref." AS Cat FROM TO_ZVRR
UNION ALL SELECT Part_Number, CRD_Qty*-1, CRD_Date, Format([CRD_Date], "MM.YYYY"), "From_Ref" FROM FR_ZVRR
INNER JOIN Planner ON FG_PN_LISTS.Part_Number = ZVRR_TO_FR.Part_Number;

Thanks & Regards,
Rajeshkumar R

[ssanfu]

AFAIK, that cannot be done in a Union query.

Create a new query. Add the union query “ZVRR_TO_FR” and the table “Planner” and create the inner join, then add the fields to the query grid.