Forum Discussion
Query for same PCFN and different Carrier
See below. I am trying to write a query that the "PCFN" is the same that only includes a different "Carrier" name. I keep getting that something like ( , etc is wrong. Can anyone look at what is wro...
I am confused. Where is table "T" located in the linked query? Did you make it?
- if you open Query1 in SQL view, you will see that T is just an Alias for the sub-query.
I added table 1 to a design query and then added table 1 again and went to properties of the second table one and renamed it then saving it. Now I have all the exact fields as named in table 1. How do I get CNT into the renamed table without changing the original table 1 design? ;arnel_gp
- upload the db you have so i can see what you did.
do you believe i am poor in algebra especially on worded problem?