請問我有一個如下的查詢語法： select field1,field2 from table1 where field1 like % and field1 like "% and field1 like 3%... 因為field1要like的值很多，如果我將like的值用另一個table2整理好， 有類似selec * from table1 where field1 in (selec field1 from table2)的 查詢方法,但是是用"like"的語法嗎？

Hi sera,    

In Oracle :
select  *
from    table1 t1
where   exists (select 'exists' from table2 t2 where t1.id like '%' || t2.id || '%')    In SQL Server :
select  *
from    table1 t1
where   exists (select 'exists' from table2 t2 where t1.id like '%'   t2.id   '%')

發表人 -

------
Fishman

Select field1, field2 From table1 Where field1 like % And field1 like "% And field1 like 3% And field1 in (Select field1 From table2 Where field1 like D%) 不知道這是不是妳所要的, 希望對妳有所幫助.

sorry....i can't type chinese and my english is poor...  >

謝謝三位的答覆~我了解了