LIKE in JOIN

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

Re: LIKE in JOIN

JackpipE wrote in
news:1194146684.611859.261280@o3g2000hsb.googlegroups.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