SQL Query

Current in the database there are a number of different queries to make up one query.  Can someone please tell me how I can join all the select statements to get just one procedure instead of the 14 I currently have.

Thanks

TABLE qselSumHV UNION ALL TABLE qselSumPA UNION ALL TABLE qselSumConnections UNION ALL TABLE qselSumDT UNION ALL TABLE qselSumSP UNION ALL TABLE qselSumMA UNION ALL TABLE qselSumPY UNION ALL TABLE qselSumHVSB UNION ALL TABLE qselSumWW UNION ALL TABLE qselSumExam UNION ALL TABLE qselSumDentrix UNION ALL TABLE qselSumVO UNION ALL TABLE qselSumConnectionsVO;


SELECT DISTINCTROW tblHVIntake.lngVisitId, tblHVIntake.dtmContact, "Health Van" AS [With], "qselSumHV" AS [Table], tblHVIntake.lngPatientId
FROM tblHVIntake;

SELECT DISTINCTROW tblPAVisit.lngVisitID, tblPAVisit.dtmContact, "Prescription Assistance" AS [With], "qselSumPA" AS [Table], tblPAVisit.lngPatientID
FROM tblPAVisit;

SELECT DISTINCTROW SQL_tblMHCIntake.lngIntakeId AS lngVisitId, SQL_tblMHCIntake.dtmIntake, "Connections" AS [With], "qselSumConnections" AS [Table], SQL_tblMHCIntake.lngPatientId
FROM SQL_tblMHCIntake;


SELECT DISTINCTROW tblDTIntake.lngVisitId, tblDTIntake.dtmContact, "Dental Program - Old" AS [With], "qselSumDT" AS [Table], tblDTIntake.lngPatientId
FROM tblDTIntake;

SELECT DISTINCTROW tblSPIntake.lngVisitId, tblSPIntake.dtmContact, "Specialty Clinic" AS [With], "qselSumSP" AS [Table], tblSPIntake.lngPatientId
FROM tblSPIntake;

SELECT DISTINCTROW tblMAIntake.lngVisitId, tblMAIntake.dtmContact, "Mammogram" AS [With], "qselSumMA" AS [Table], tblMAIntake.lngPatientId
FROM tblMAIntake;

SELECT DISTINCTROW tblPYIntake.lngVisitId, tblPYIntake.dtmAppointment, IIf([bytType]=0,"Psych Intake","Psych Monitor") & Switch([bytAppt]=4," - Excused",[bytAppt]=9," - No Show") AS [With], "qselSumPY" AS [Table], tblPYIntake.lngPatientId
FROM tblPYIntake;

SELECT DISTINCTROW tblSBHeader.lngSuperId AS lngVisitId, tblSBHeader.dtmDate, "Health Van Superbill" AS [With], "qselSumHVSB" AS [Table], tblSBHeader.lngPatientId
FROM tblSBHeader
WHERE (((tblSBHeader.lngClinicId)>9));

SELECT DISTINCTROW tblSBHeader.lngSuperId AS lngVisitId, tblSBHeader.dtmDate, "Well Womens" AS [With], "qselSumWW" AS [Table], tblSBHeader.lngPatientId
FROM tblSBHeader
WHERE (((tblSBHeader.lngClinicId)=1));

SELECT DISTINCTROW tblHBHeader.lngSuperId AS lngVisitId, tblHBHeader.dtmDate AS dtmContact, Switch([bytType]=0,"Health Consult",[bytType]=1,"Short Intake",[bytType]=2,"Immunization",[bytType]=3,"Phone Intake",[bytType]=4,"Class Intake") AS [With], "qselSumExam" AS [Table], tblHBHeader.lngPatientId
FROM tblHBHeader;


SELECT DISTINCTROW DDB_APPT_BASE.APPTID AS lngVisitId, IIf([APPTDATE]>#1/1/1900#,[APPTDATE],[BROKENDATE]) AS APPT, "Dental Program - Dentrix" & IIf([APPTDATE]<#1/1/1900#,"  *Broken Visit*") AS [With], "None" AS [Table], qjcmChartNumDentrix.MinOflngPatientId AS lngPatientId
FROM (DDB_PAT_BASE INNER JOIN DDB_APPT_BASE ON DDB_PAT_BASE.PATID = DDB_APPT_BASE.PATID) INNER JOIN qjcmChartNumDentrix ON DDB_PAT_BASE.CHART = qjcmChartNumDentrix.strPatientId
WHERE (((DDB_APPT_BASE.STATUS)=150)) OR (((DDB_APPT_BASE.APPTDATE)<#1/1/1900#));

SELECT DISTINCTROW tblVOVoucher.lngVoucherId AS lngVisitId, tblVOVoucher.dtmDate, "Voucher from " & nz([strProg]," *Not specified*") AS [With], "none" AS [Table], tblVOVoucher.lngPatientId
FROM tblVOVoucher
WHERE (((tblVOVoucher.strProg)<>"PB" And (tblVOVoucher.strProg)<>"TR"));


SELECT DISTINCTROW SQL_tblMHC_Voucher.lngVoucherId AS lngVisitId, SQL_tblMHC_Voucher.dtmCreate, "Connections Voucher" AS [With], "qselSumConnectionsVO" AS [Table], SQL_tblMHC_Voucher.lngPatientId
FROM SQL_tblMHC_Voucher;
Start Free Trial