>hi all,
>i have a friend who is trying to do a sql command but is not having any luck. basically he wants to return field1 from table 1 where field2 occurs in field1. i am not great with sub querys but is this easy/possible to do? i suppose it would go something like in pyudocode
>
>select table1.field1 from table1 where table1.field2 is found anywhere in table1.field1
>
>~M
Can you post some exaple data and desired result? Because the question is not clear (at least for me).
What value of Field2 must be in field1? ALL or just first or some other?
Against Stupidity the Gods themselves Contend in Vain - Johann Christoph Friedrich von Schiller
The only thing normal about database guys is their tables.