Compare one field to many fields in query

[johnawebbhsd]

Help, confulsed

This is probably easy, I just can't seem to make it work. I have Table[msgln] and Table[clean]. I need to query [msgln]:mbox to 8 fields in [clean] desc1,desc2,desc3,desc4,desc5,desc6,desc7,desc8). I am trying to do so using a make-table query. My last attempt was to join [msgln]:mbox to [clean]:desc1, [clean_1]:desc2, etc... this query ran for over 2 hours and wasn't close to being done yet. Also note that the mbox could have a match in all desc fields, but I don't want to see 8 rows of data. would like the new table to have columns of

mbox desc1 desc2 desc3 etc...

Any tips or can you try to point me in right direction????

 

[Russell Hauf]

Now I'm confused too!

Can you specify what exactly you're trying to do? When you say,
"I need to query [a] to 8 fields in ,"
it doesn't really say what you're looking for. Maybe give an example using your data.

Thank you!

-rh

 

[johnawebbhsd]

table a has phone numbers in column 1.
table b has phone numbers in column 1,2,3,4,5,6,7,8.

We are tryinq to query the phone # in table a to all phone numbers in table b and return any matches. However, if the phone number matches more than one column in table b, I only want one match returned not multiples.

ex.
table a column 1= 5555551234
table b column 1,2,3=5555551234 4,5,6=1234 and 7,8 blank

return one match (row) showing the data from all 8 fields in the new table.

Thanks for your help