I have 4 Queries (Query1; Query2; Query3; Query4), I want to join the 4 queries into one query that would do what the 4 do, but I don't know how to do it. Can anyone help?
The SQL code for each query 1 is as follows:
Query1 - "SELECT DISTINCT ProductsACTIVE.PZN_Code, ProductsACTIVE.tbl_HMR_Product_Name, ProductsACTIVE.tbl_HMR_Pack_Form, ProductsACTIVE.tbl_HMR_Pack_Strength, ProductsACTIVE.tbl_HMR_Class_Code_1, ProductsACTIVE.tbl_HMR_Market_Segment_3, ProductsACTIVE.tbl_HMR_Market_Segment_6, ProductsACTIVE.tbl_HMR_Class_Code_5, ProductsACTIVE.Product_Type FROM ProductsACTIVE WHERE (((ProductsACTIVE.tbl_HMR_Market_Segment_3)=1) AND ((ProductsACTIVE.tbl_HMR_Market_Segment_6)=1) AND ((ProductsACTIVE.Product_Type)="Health Product")) OR (((ProductsACTIVE.tbl_HMR_Market_Segment_3)=1) AND ((ProductsACTIVE.tbl_HMR_Class_Code_5) Like "H26.4.*") AND ((ProductsACTIVE.Product_Type)="Health Product")) ORDER BY ProductsACTIVE.tbl_HMR_Product_Name, ProductsACTIVE.tbl_HMR_Pack_Form, ProductsACTIVE.tbl_HMR_Pack_Strength, ProductsACTIVE.tbl_HMR_Class_Code_1; "
Query2 - "SELECT Query1.tbl_HMR_Product_Name, Query1.tbl_HMR_Pack_Form, Query1.tbl_HMR_Pack_Strength, Query1.tbl_HMR_Class_Code_1 FROM Query1 GROUP BY Query1.tbl_HMR_Product_Name, Query1.tbl_HMR_Pack_Form, Query1.tbl_HMR_Pack_Strength, Query1.tbl_HMR_Class_Code_1; "
Query3 - "SELECT Query2.tbl_HMR_Product_Name, Query2.tbl_HMR_Pack_Form, Query2.tbl_HMR_Pack_Strength, Count(Query2.tbl_HMR_Class_Code_1) AS CountOftbl_HMR_Class_Code_1 FROM Query2 GROUP BY Query2.tbl_HMR_Product_Name, Query2.tbl_HMR_Pack_Form, Query2.tbl_HMR_Pack_Strength HAVING (((Count(Query2.tbl_HMR_Class_Code_1))>1)); "
Query4 - "SELECT ProductsACTIVE.PZN_Code, ProductsACTIVE.tbl_HMR_Prod_Pack_Code, ProductsACTIVE.tbl_HMR_Pack_Desc, ProductsACTIVE.tbl_HMR_Product_Name, ProductsACTIVE.tbl_HMR_Pack_Form, ProductsACTIVE.tbl_HMR_Pack_Strength, ProductsACTIVE.tbl_HMR_Class_Code_1 FROM ProductsACTIVE INNER JOIN Query3 ON (ProductsACTIVE.tbl_HMR_Pack_Strength = Query3.tbl_HMR_Pack_Strength) AND (ProductsACTIVE.tbl_HMR_Pack_Form = Query3.tbl_HMR_Pack_Form) AND (ProductsACTIVE.tbl_HMR_Product_Name = Query3.tbl_HMR_Product_Name);"
Thank you,
Patekos