I am wondering if anyone can help me I have two select queries QUERY1 which has the following SQL CODE:
SELECT PART.ID, PART.DESCRIPTION, PLANNED_MATL_REQ.PARENT_PART_ID, PLANNED_MATL_REQ.REQUIRED_PART_ID, PLANNED_MATL_REQ.REQUIRED_DATE, PLANNED_MATL_REQ.REQUIRED_QTY
FROM PART INNER JOIN PLANNED_MATL_REQ ON PART.ID = PLANNED_MATL_REQ.REQUIRED_PART_ID
WHERE (((PART.ID) Like "*RM"));
and a second query called QUERY2 which calls QUERY1 and some other columns from a table.
SELECT Query1.ID, Query1.DESCRIPTION, Query1.PARENT_PART_ID, Query1.REQUIRED_PART_ID, Query1.REQUIRED_DATE, Query1.REQUIRED_QTY, PART.PRODUCT_CODE
FROM PART INNER JOIN Query1 ON PART.ID = Query1.PARENT_PART_ID;
Both tables are in the same database. I am trying to stream line this into one SQL Command and now have to base a query on a query can someone help?