Select a1,a2,a3 From 表1 Select a1,c2,c3 From 表2 Select 表1.a1,a2,a3,c2,c3 From 表1,表2 Where 表1.a1=表2.a1 这么拼接在一块,怎么实现?(表1,表2也可能是同一张表) 下面是SAS程序能实现: proc sql; create table a0 as select distinct b.frec_ladle_opening_time as ld_open,a.* from a0 a,dl_L3.tmmsm25 b where a.htno=b.htno order by ld_open; quit;
|