combining multiple select statement

[Pgiegucz]

Is it possible to combine these select statements into one select statement???


select s.beginmileage, s.endmileage
from DTS_PoliceTriplog_tmp s
left join payRollLookup p
on s.PayrollNo=p.payrollNo
left join locationlookup l
on s.locationno=l.locationno
left join vehicllookup v
on s.vehicleNo=v.vehicleNo
where beginmileage = endmileage and directory = 'police Logs'

select s.calculatedmiles from DTS_PoliceTriplog_tmp s
where calculatedmiles < '0' and directory = 'police logs'

(select s.payrollno from DTS_PoliceTriplog_tmp s
where s.payrollno not in (select payrollno from qalookup) and directory = 'police logs')

(select s.locationno from DTS_PoliceTriplog_tmp s
where s.locationno not in (select locationno from locationlookup) and directory = 'police logs')

(select s.vehicleno from DTS_PoliceTriplog_tmp s
where s.vehicleNo not in (select vehicleNo from vehicllookup) and directory = 'police logs')

 

[sguslan]

Use SQL UNION to combine row sets from different queries. There is a catch though. All queries in a union have to have the same number of columns with respective columns having the same type.
So if column 1 of query 1 has INTeger data type then column 1 of all queries in the union has to be INTeger type.

Example:
SELECT INT_ID, CHAR_FIELD FROM TABLE1
UNION
SELECT INT_ANOTHER_ID, CHAR_NAME FROM TABLE2

 

[tlbroadbent]

You need to explain what final result you expect. Which columns should be in the result set? If you want to get the best answer for your question read faq183-874 and thread183-468158.
Terry L. Broadbent - DBA
SQL Server Page:

http://tlbroadbent.home.attbi.com/sql/sql_articles.htm