Two or more select statements in a single query

[bharathi228]

How to write two or more select statements in a single query

here my requirement is

SELECT dbo.SYS_PARAMS. PARAMETER_NAME, dbo.SYS_PARAMS. PARAMETER_UNITS , SYSTEM2.dbo.CAL IBRATION.CAL_TY PE,
SYSTEM2.dbo.CAL IBRATION.CAL_TI MESTAMP, SYSTEM2.dbo.CAL IBRATION.MEASUR ED_VAL, SYSTEM2.dbo.CAL IBRATION.EXPECT ED_VAL
FROM SYSTEM2.dbo.CAL IBRATION INNER JOIN
dbo.SYS_PARAMS ON SYSTEM2.dbo.CAL IBRATION.PARAME TER_INDEX = dbo.SYS_PARAMS. PARAMETER_INDEX INNER JOIN
dbo.REPORT_PARA METERS ON dbo.SYS_PARAMS. PARAMETER_INDEX = dbo.REPORT_PARA METERS.PARAMETE R_INDEX AND
dbo.REPORT_PARA METERS.REPORT_I NDEX = 530 AND SYSTEM2.dbo.CAL IBRATION.CAL_TY PE IN ('qtr_low', 'Qtr_high', 'Qtr_mid')

----------------------------------------
select SYSTEM2.dbo.CAL IBRATION.expect ed_val-SYSTEM2.dbo.CAL IBRATION.measur ed_val as LOW_DIFF where cal_type='QTR_L OW'
-----------------------------------------

select SYSTEM2.dbo.CAL IBRATION.expect ed_val-SYSTEM2.dbo.CAL IBRATION.measur ed_val as MID_DIFF where cal_type='QTR_M ID'

----------------------------------------------------

select SYSTEM2.dbo.CAL IBRATION.expect ed_val-SYSTEM2.dbo.CAL IBRATION.measur ed_val as HIGH_DIFF where cal_type='QTR_H IGH'

-------------------------------------

i want to combine all these statements form in a single query as a view


after creating view i have to bind this view to crystal report and i want to use all those fields

Timestamp,Expec ted_val,measure d_val,result,LO W_DIFF,HIGH_DIF F,MID_DIFF


pls any one help me with this

[ck9663]

Try to match your columns then use UNION


-- CK