I have two searching pages in asp. They are searching by checkbox selections. Now I want to merge those two pages together. Below are the 2 sql I used. Questions is how to merge those 2 sql together. Please put in consideration as the user might not select checkbox on either pages.
strSQL1 ="SELECT DISTINCT table1.* FROM table1 LEFT JOIN Specialty ON table1.FirmID = Specialty.FirmID where Specialty_Master.Specialty_details in ('" & strResult & "') order by table1.FirmName;"
strSQL2 ="SELECT DISTINCT table1 FROM table1 LEFT JOIN Discipline_detail ON table1.FirmID = Discipline_detail.FirmID WHERE (((" & Architecture & "=False) OR Discipline_detail.[Architecture]=" & Architecture & ") AND ((Discipline_detail.[Civil/Site_Engineering]=" & Civil_Site_Engineer & ") or (" & Civil_Site_Engineer & "=False)) ) ORDER BY table1.FirmName;"
Thanks in advance.