LIKE in JOIN

[JackpipE]

I have 2 tables and the only unique and common identifier is part of
url:

TABLE1.url
/legal500_html/us500/edit/usv1_in1.htm

TABLE2.url
http....html/us500/edit/usv1_in2.htmincludes/
get_content_page_l500.....

the TABLE2 url have 3 different formats so extracting the common part
of the string in not an option. The only solution comes to my mind is
to use LIKE on TABLE1.url.
Can I use LIKE on JOIN? I couldn't figure it out so far.

Thanks,
Jack

[Bob Quintal]

JackpipE <pi*******@gmail.comwrote in
news:11**********************@o3g2000hsb.googlegro ups.com:

I have 2 tables and the only unique and common identifier is part

of

url:

TABLE1.url
/legal500_html/us500/edit/usv1_in1.htm

TABLE2.url
http....html/us500/edit/usv1_in2.htmincludes/
get_content_page_l500.....

the TABLE2 url have 3 different formats so extracting the common

part

of the string in not an option. The only solution comes to my mind

is

to use LIKE on TABLE1.url.
Can I use LIKE on JOIN? I couldn't figure it out so far.

Thanks,
Jack

Yes, you can. Build the query with an inner join, then switch from
Design View to SQL view, clange the = to like, add wildcards, and
save the query. NEVER attempt to open in design view after making
the changes.
TABLE1.url LIKE "*" & TABLE2.url & "*"

--
Bob Quintal

PA is y I've altered my email address.

--
Posted via a free Usenet account from http://www.teranews.com