a guest Aug 20th, 2019 73 Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
- SELECT field1,field2,field3
- FROM table1
- where field3 like '%'+(SELECT distinct field from table2)+'%'
- SELECT t1.field1, t1.field2, t1.field3
- table1 t1
- (SELECT distinct field AS fieldx from table2) t2
- ON t1.field3 like CONCAT('%',fieldx,'%')
RAW Paste Data