Добрый день всем,
Пытаюсь сделать SQL UNION, получаю ошибку, что техт дата не может использоваться в
UNION. Подскажите пожалуйста если есть какойто другой способ для етого.


Zaranee vsem spasibo

SQL Server 2000
Eto original zapros..
SELECT Work_Order_Header.Id,
Work_Order_Header.Oid,
Work_Order_Header.Description,
Work_Order_Header.Status_sym,
aircraft_data.Aircraft_id,
Work_Order_header.Aircraft_Hours,
Work_Order_header.Aircraft_Landings,
Work_Order_data.Actual_Start_date,
Work_order_data.Planned_start_Date,
Work_order_Data.Maint_task_oid,
Work_order_data.OId,
Work_order_data.discrepancy,
worm_order_data.corrective_action,
work_order_data.Sequence_no,
Location_master.Location_Id,
work_order_Data.actual_close_date,
work_order_data.status_sym,

'date_arr' = (select top 1 actual_time_in
from flight_Data
where actual_time_in <=

work_order_header.start_date and
status_sym = 'Completed' and
aircraft_oid = Work_Order_Header.aircraft_Oid
order by actual_time_in desc),
'barcoded_oid' = '*0' + convert(varchar(12),work_order_Data.oid) + '*'
FROM Work_Order_data,
Work_Order_Header,
aircraft_data,
Location_master
WHERE

( Work_Order_data.WO_Header_Oid = Work_Order_Header.Oid ) and
( Work_Order_Header.aircraft_Oid *= aircraft_data.oid ) and
/*( Work_Order_Header.city_Oid *= Location_master_Hdr.oid ) and*/
Work_order_data.city_oid *= Location_master.oid and
work_order_data.Sequence_no is not null



Mne nujno prisoedinit' esche 3 tablizi k etomu, i condition.... Dumala chto budet luchshe cherez union..,no Work_order_data.discrepancy i work_order_Data.corrective Action TEXT, i zapros s union vidaet oshibku.

Konechno otnositsia.. Query ispolzuetsia v PowerBuilder Datawindow

столбцы которых раного типа

net, vse stolbzi chto ia ispolzuiu odinakovogo tipa. Query identichnie, tolko vo vtoroi polovine ia prisoediniau esche 3 tablizi..

Orgomnoe Spasibo vsem za pomosch.