[SQL] 尋找區間內物件

create table hg18_encode_region_match_cgh

select t1.*, t2.ID, t2.nstart_pos, t2.nend_pos, concat(t2.band1,t2.band2) as band, t2.gene_sym, t2.gene_name from hg18_encode_region as t1, cell_cycle_10meant_INFO as t2

WHERE

t1.chr = t2.chrom

and

t1.start_pos <= t2.nend_pos

and

t2.nstart_pos <= t1.end_pos