|
vision.v1
Yak Posting Veteran
67 Posts |
 Posted - 11/12/2012 : 04:56:25
|
Hi,
I would like to join two tables based on fields of varchar() types
The difference here is that this 'ON' condition will not be a conventional one like this
SELECT * from
TABLE_A as A
inner join TABLE_B as B
on A.Col=B.Col
Instead I want to be a join based on pattern matching
SELECT * from
TABLE_A as A
inner join TABLE_B as B
on A.Col LIKE 'B.Col%'
Please Advise.
|
|
Using LIKE Pattern matching for joining tables
