I am trying to write a query that will complete the following task.

I have 3 tables that have a Description field. Each Table (named 1-3) contains different information. When a search is started this is what needs to happen. I need the three description fields to concatenate Then I need to run a search on that new concatenated field. I have tried to execute the following query.

SELECT Field1,field2, field3 = table1.description, table2.description, table3.description
FROM Table1,Table2,Table3
where Field3 = "@Description"

The error that I get is that Field 3 does not exist. But if I remove the where Statement the Query returns fine.

I am starting to think that what I need to do is design a pivot table that has the concatenation already done and contains the information that I need. Then run the query. The problem with that is the table will be 20,000 plus records and would require a lot of manual data entry.

Thanks in Advance.
Please e-mail me so I don`t miss a post.
Chris
crs@intyellopages.com