If this is your first visit, be sure to
check out the FAQ by clicking the
link above. You may have to register
before you can post: click the register link above to proceed. To start viewing messages,
select the forum that you want to visit from the selection below.

Unanswered: Selecting records by substring using list of strings

Need a method to select records based on finding a sub-string in a column in one table using a list of strings from another sub-select. Sub-select produces a vector(single column) of values that will be used to locate matching sub-string in another column in a different table. My question is basically what is the approach to solving this query? I don't see a join being possible since the two tables have no exact matching fields. Want to output only those records from table 1 where one of the strings in the sub-select or table 2...anyway my brain is fried looking at this....thanks for any info.

A join-condition is a search-condition, except that:
•It cannot contain any subqueries, scalar or otherwise
•It cannot include any dereference operations or the DEREF function, where the reference value is other than the object identifier column
•It cannot include an SQL function
•Any column referenced in an expression of the join-condition must be a column of one of the operand tables of the associated join (in the scope of the same joined-table clause)
•Any function referenced in an expression of the join-condition of a full outer join must be deterministic and have no external action
•It cannot include an XMLQUERY or XMLEXISTS expression
An error occurs if the join condition does not comply with these rules (SQLSTATE 42972).