Hi,
can anyone explain me why this is
happening?
In oppinion I have events.v_date in the
result!
___________________
select distinct
events.id,events.v_date
from events
where
(events.aid & 1) <> 0
and
((events.expires = 't' and events.v_date >
989994114) or (events.expires = 'f'))
INTERSECT
select distinct
events.id,events.v_date
from events,event_ref
where 1=1 and (events.id =
event_ref.event_id and event_ref.ref_id =
'team_3af2a2ba2f93a')
order by events.v_date
___________________
returns:
ERROR: ORDER BY on a
UNION/INTERSECT/EXCEPT result must be on one of the result
columns
Thank you in advance,
Alex
--
___________________________
Human Touch Medienproduktion GmbH
Am See 1
17440 Klein Jasedow
Alexander Lohse
Tel: (038374) 75211
Fax: (038374) 75223
eMail: al@humantouch.de
http://www.humantouch.de