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.htminc ludes/
get_content_pag e_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]

Re: LIKE in JOIN

JackpipE <pipe.jack@gmai l.comwrote in
news:1194146684 .611859.261280@ o3g2000hsb.goog legroups.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.htminc ludes/
get_content_pag e_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