Demo entry 6782232

Sybase

   

Submitted by cherie on Jan 10, 2019 at 18:21
Language: Transact-SQL. Code size: 165 Bytes.

select * from mytab a join urtab b on a.myid=b.urid and 
exists (select 1 from ourtab c where c.ourid=a.myid and c.ourid=upper(b.urid))
where b.date > '2015-01-01'

This snippet took 0.00 seconds to highlight.

Back to the Entry List or Home.

Delete this entry (admin only).