If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
How to merge these 2 queries
Here comes some hefty SQL code:
qryNewRebuildReport SELECT tblproductpartlist.productid, tblproductpartlist.imwpartnumberid, tblproductpartlist.onekmaint, tblproductpartlist.fivekrebuild, tblproductpartlist.tenkrebuild, tblproductpartlist.ftkrebuild, tblproductpartlist.twkrebuild, tblproductpartlist.twfkthourebuild, tblproductpartlist.thkrebuild, tblproductpartlist.thfkrebuild, tblproductpartlist.ftykrebuild FROM tblproductpartlist WHERE ( ( ( tblproductpartlist.productid ) = 1935 ) AND ( ( tblproductpartlist.onekmaint ) = "y" ) ) OR ( ( ( tblproductpartlist.productid ) = 1935 ) AND ( ( tblproductpartlist.fivekrebuild ) = "y" ) ) OR ( ( ( tblproductpartlist.productid ) = 1935 ) AND ( ( tblproductpartlist.tenkrebuild ) = "y" ) ) OR ( ( ( tblproductpartlist.productid ) = 1935 ) AND ( ( tblproductpartlist.ftkrebuild ) = "y" ) ) OR ( ( ( tblproductpartlist.productid ) = 1935 ) AND ( ( tblproductpartlist.twkrebuild ) = "y" ) ) OR ( ( ( tblproductpartlist.productid ) = 1935 ) AND ( ( tblproductpartlist.twfkthourebuild ) = "y" ) ) OR ( ( ( tblproductpartlist.productid ) = 1935 ) AND ( ( tblproductpartlist.thkrebuild ) = "y" ) ) OR ( ( ( tblproductpartlist.productid ) = 1935 ) AND ( ( tblproductpartlist.thfkrebuild ) = "y" ) ) OR ( ( ( tblproductpartlist.productid ) = 1935 ) AND ( ( tblproductpartlist.ftykrebuild ) = "y" ) ); i am figureing i need to do a sub query, but how do i get the above to work with the below: SELECT qrynewrebuildreport.productid, qrynewrebuildreport.imwpartnumberid, qrynewrebuildreport.onekmaint, "1 1000 Hr Service" AS intervaldescription, 1000 AS intervallink FROM qrynewrebuildreport WHERE (( ( qrynewrebuildreport.onekmaint ) = "y" )) Union SELECT qrynewrebuildreport.productid, qrynewrebuildreport.imwpartnumberid, qrynewrebuildreport.fivekrebuild, "2 5000 Hr Rebuild" AS intervaldescription, 5000 AS intervallink FROM qrynewrebuildreport WHERE (( ( qrynewrebuildreport.fivekrebuild ) = "y" )) Union SELECT qrynewrebuildreport.productid, qrynewrebuildreport.imwpartnumberid, qrynewrebuildreport.tenkrebuild, "3 10000 Hr Rebuild" AS intervaldescription, 10000 AS intervallink FROM qrynewrebuildreport WHERE (( ( qrynewrebuildreport.tenkrebuild ) = "y" )) Union SELECT qrynewrebuildreport.productid, qrynewrebuildreport.imwpartnumberid, qrynewrebuildreport.ftkrebuild, "4 15000 Hr Rebuild" AS intervaldescription, 15000 AS intervallink FROM qrynewrebuildreport WHERE (( ( qrynewrebuildreport.ftkrebuild ) = "y" )) Union SELECT qrynewrebuildreport.productid, qrynewrebuildreport.imwpartnumberid, qrynewrebuildreport.twkrebuild, "5 20000 Hr Rebuild" AS intervaldecription, 20000 AS intervallink FROM qrynewrebuildreport WHERE (( ( qrynewrebuildreport.twkrebuild ) = "y" )) Union SELECT qrynewrebuildreport.productid, qrynewrebuildreport.imwpartnumberid, qrynewrebuildreport.twfkthourebuild, "6 25000 Hr Rebuild" AS intervaldescription, 25000 AS intervallink FROM qrynewrebuildreport WHERE (( ( qrynewrebuildreport.twfkthourebuild ) = "y" )) Union SELECT qrynewrebuildreport.productid, qrynewrebuildreport.imwpartnumberid, qrynewrebuildreport.thkrebuild, "7 30000 Hr Rebuild" AS intervaldescription, 30000 AS intervallink FROM qrynewrebuildreport WHERE (( ( qrynewrebuildreport.thkrebuild ) = "y" )) Union SELECT qrynewrebuildreport.productid, qrynewrebuildreport.imwpartnumberid, qrynewrebuildreport.thfkrebuild, "8 35000 Hr Rebuild" AS intervaldescription, 35000 AS intervallink FROM qrynewrebuildreport WHERE (( ( qrynewrebuildreport.thfkrebuild ) = "y" )) UNION SELECT qrynewrebuildreport.productid, qrynewrebuildreport.imwpartnumberid, qrynewrebuildreport.ftykrebuild, "9 40000 Hr Rebuild" AS intervaldescription, 40000 AS intervallink FROM qrynewrebuildreport WHERE (( ( qrynewrebuildreport.ftykrebuild ) = "y" )); -- As always, any and all help appreciated! |
#2
|
|||
|
|||
How to merge these 2 queries
forget i asked. just figured it out.
-- As always, any and all help appreciated! "DawnTreader" wrote: Here comes some hefty SQL code: qryNewRebuildReport SELECT tblproductpartlist.productid, tblproductpartlist.imwpartnumberid, tblproductpartlist.onekmaint, tblproductpartlist.fivekrebuild, tblproductpartlist.tenkrebuild, tblproductpartlist.ftkrebuild, tblproductpartlist.twkrebuild, tblproductpartlist.twfkthourebuild, tblproductpartlist.thkrebuild, tblproductpartlist.thfkrebuild, tblproductpartlist.ftykrebuild FROM tblproductpartlist WHERE ( ( ( tblproductpartlist.productid ) = 1935 ) AND ( ( tblproductpartlist.onekmaint ) = "y" ) ) OR ( ( ( tblproductpartlist.productid ) = 1935 ) AND ( ( tblproductpartlist.fivekrebuild ) = "y" ) ) OR ( ( ( tblproductpartlist.productid ) = 1935 ) AND ( ( tblproductpartlist.tenkrebuild ) = "y" ) ) OR ( ( ( tblproductpartlist.productid ) = 1935 ) AND ( ( tblproductpartlist.ftkrebuild ) = "y" ) ) OR ( ( ( tblproductpartlist.productid ) = 1935 ) AND ( ( tblproductpartlist.twkrebuild ) = "y" ) ) OR ( ( ( tblproductpartlist.productid ) = 1935 ) AND ( ( tblproductpartlist.twfkthourebuild ) = "y" ) ) OR ( ( ( tblproductpartlist.productid ) = 1935 ) AND ( ( tblproductpartlist.thkrebuild ) = "y" ) ) OR ( ( ( tblproductpartlist.productid ) = 1935 ) AND ( ( tblproductpartlist.thfkrebuild ) = "y" ) ) OR ( ( ( tblproductpartlist.productid ) = 1935 ) AND ( ( tblproductpartlist.ftykrebuild ) = "y" ) ); i am figureing i need to do a sub query, but how do i get the above to work with the below: SELECT qrynewrebuildreport.productid, qrynewrebuildreport.imwpartnumberid, qrynewrebuildreport.onekmaint, "1 1000 Hr Service" AS intervaldescription, 1000 AS intervallink FROM qrynewrebuildreport WHERE (( ( qrynewrebuildreport.onekmaint ) = "y" )) Union SELECT qrynewrebuildreport.productid, qrynewrebuildreport.imwpartnumberid, qrynewrebuildreport.fivekrebuild, "2 5000 Hr Rebuild" AS intervaldescription, 5000 AS intervallink FROM qrynewrebuildreport WHERE (( ( qrynewrebuildreport.fivekrebuild ) = "y" )) Union SELECT qrynewrebuildreport.productid, qrynewrebuildreport.imwpartnumberid, qrynewrebuildreport.tenkrebuild, "3 10000 Hr Rebuild" AS intervaldescription, 10000 AS intervallink FROM qrynewrebuildreport WHERE (( ( qrynewrebuildreport.tenkrebuild ) = "y" )) Union SELECT qrynewrebuildreport.productid, qrynewrebuildreport.imwpartnumberid, qrynewrebuildreport.ftkrebuild, "4 15000 Hr Rebuild" AS intervaldescription, 15000 AS intervallink FROM qrynewrebuildreport WHERE (( ( qrynewrebuildreport.ftkrebuild ) = "y" )) Union SELECT qrynewrebuildreport.productid, qrynewrebuildreport.imwpartnumberid, qrynewrebuildreport.twkrebuild, "5 20000 Hr Rebuild" AS intervaldecription, 20000 AS intervallink FROM qrynewrebuildreport WHERE (( ( qrynewrebuildreport.twkrebuild ) = "y" )) Union SELECT qrynewrebuildreport.productid, qrynewrebuildreport.imwpartnumberid, qrynewrebuildreport.twfkthourebuild, "6 25000 Hr Rebuild" AS intervaldescription, 25000 AS intervallink FROM qrynewrebuildreport WHERE (( ( qrynewrebuildreport.twfkthourebuild ) = "y" )) Union SELECT qrynewrebuildreport.productid, qrynewrebuildreport.imwpartnumberid, qrynewrebuildreport.thkrebuild, "7 30000 Hr Rebuild" AS intervaldescription, 30000 AS intervallink FROM qrynewrebuildreport WHERE (( ( qrynewrebuildreport.thkrebuild ) = "y" )) Union SELECT qrynewrebuildreport.productid, qrynewrebuildreport.imwpartnumberid, qrynewrebuildreport.thfkrebuild, "8 35000 Hr Rebuild" AS intervaldescription, 35000 AS intervallink FROM qrynewrebuildreport WHERE (( ( qrynewrebuildreport.thfkrebuild ) = "y" )) UNION SELECT qrynewrebuildreport.productid, qrynewrebuildreport.imwpartnumberid, qrynewrebuildreport.ftykrebuild, "9 40000 Hr Rebuild" AS intervaldescription, 40000 AS intervallink FROM qrynewrebuildreport WHERE (( ( qrynewrebuildreport.ftykrebuild ) = "y" )); -- As always, any and all help appreciated! |
Thread Tools | |
Display Modes | |
|
|