Subject Re: left join / first row select
Author Norbert
> Preparing query: SELECT a.CON_ID, a.* FROM XRD_RC_DATA_VIEW_F a

What is XRD_RC_DATA_VIEW_F?, a table or view ?

test:
select * from data_summary a
join ( select * from data_view group by 1,2,3 ) b on a.d_1= b.d_2

Norbert

--
..
TetraSys

http://www.tetrasys.eu