Pass Through Query Only shows data from one table, WHY??

[MFS]

My Pass Through Query Looks like this . . . . .

select date_1,Time_1,Cope_Temp_1_L,Cope_temp_1_R, Drag_Temp_1_L,Drag_Temp_1_R,Location_1,Cavity_1, Device_1 from dbo.Cell_1_TT_Device_1 

select date_2,Time_2,Cope_Temp_2_L,Cope_temp_2_R, Drag_Temp_2_L,Drag_Temp_2_R,Location_2,Cavity_2, Device_2 from dbo.Cell_1_TT_Device_2

select date_3,Time_3,Cope_Temp_3_L,Cope_temp_3_R, Drag_Temp_3_L,Drag_Temp_3_R,Location_3,Cavity_3, Device_3 from dbo.Cell_1_TT_Device_3;

But only shows data for the dbo.cell_1_TT_Device_1 ??????

[pbaldy]

Does this provide the desired result?

select date_1,Time_1,Cope_Temp_1_L,Cope_temp_1_R, Drag_Temp_1_L,Drag_Temp_1_R,Location_1,Cavity_1, Device_1 from dbo.Cell_1_TT_Device_1
UNION ALL
select date_2,Time_2,Cope_Temp_2_L,Cope_temp_2_R, Drag_Temp_2_L,Drag_Temp_2_R,Location_2,Cavity_2, Device_2 from dbo.Cell_1_TT_Device_2
UNION ALL
select date_3,Time_3,Cope_Temp_3_L,Cope_temp_3_R, Drag_Temp_3_L,Drag_Temp_3_R,Location_3,Cavity_3, Device_3 from dbo.Cell_1_TT_Device_3

[MFS]

Thanks Pbaldy, Yep that was it.

[pbaldy]

No problem.