SELECT A.BASE_ID, A.LOT_ID, A.PART_ID, A.WO FROM
(SELECT *, [WORKORDER].[BASE_ID]+ '/' + [WORKORDER].[LOT_ID] AS WO
FROM WORKORDER) A
INNER JOIN TRACE ON A.PART_ID = TRACE.PART_ID AND A.WO = TRACE.APROPERTY_1
WHERE A.PRINTED_DATE > 12/31/12
A is the subquery alias and replaces the Work_Order table on the outer query.
Open in new window