-
Design Help
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
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
|