Subject | Re: left join / first row select |
---|---|
Author | Norbert |
Post date | 2013-09-16T10:34:07Z |
> Preparing query: SELECT a.CON_ID, a.* FROM XRD_RC_DATA_VIEW_F aWhat 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