query help - combining 2 tables with no common title heading

[up4asmile]

Good afternoon,
I am hoping someone will have an idea here how to make this work.
I have one table with a column named "url"; I have another table with multiple "url" columns, named, url1, url2, url3, etc.
The url column contains all of the ones that are inside the url1, url2, url3, columns. Is there anyway I can associate them? That is the only commonality between the 2 tables.
I hope it isn't a lost cause. Thanks for your help.

[Perceptus]

Is the URL Data in both tables consistent or are there more occurences of one than the other. If you create a query and add both tables to them. Click on URL and drag your mouse to the Other URL field. This will join the data. You can adjust how this is handled if you double click the line that appears after the mouse drag.

[CJ_London]

struggling to visualise your structure, but it sounds like the table with multiple "url" columns is not normalised and I don't understand 'The url column contains all of the ones that are inside the url1, url2, url3, columns' - Can you provide some examples of what you mean (not descriptions)

e.g.
tbl1
url
http//1... http//2... http//3...

tbl2
url1........url2........url3
http//1...http//2... http//3...

[up4asmile]

Thanks to you both. I think what you said, Perceptus, will work.
Ajax, URL contains all of the urls. For URL1, URL2, URL3, each of the urls are broken out into separate columns.
URL: http://www....570.htm http://www....423.htm http://www....1162.htm
URL1: http://www....570.htm
URL2: http://www....423.htm
URL3: http://www....1162.htm
Thank you both. I'm going to try that, Perceptus. That is common sense and I should have thought of it.

[June7]

Sounds like will have to pull table with the single URL column into the query 3 times. Join one each to one of the multiple URL columns in the other table.

[up4asmile]

I thought this would work, but it doesn't. Here's a screenshot:

Basically, everything I need is inside the Monthly Advertising Query except for the number of visits. I made the relationships dependent so that it appears in both queries. (which makes sense to me). But I don't get any info with it set up this way.
???

[up4asmile]

Okay, my colleague told me to change the "and" in the relationship to "or" (using sql). That worked and I have my data. Thanks for your input! I appreciate it!