Union query
in [General]
|
Prev: I need help
Next: send to email
From: Eva on 22 Dec 2009 12:26 Hi I have two querries that are the same, except I have the criteria: - on column called Ble service - one query asks for items "TTO" the other for "OPPO" When I try to union both queries into one using sql (union all) then on the result the query asks for bble service - I can just type enter and have the result of the query, but I want to skip it - I just want to click to my union query and see the results. I am doing something wrong that it asks me for it? Thank you -- Greatly appreciated Eva
From: KARL DEWEY on 22 Dec 2009 12:53 If I understand correctly you do not need a union. Try this -- SELECT YourTable.* FROM YourTable WHERE YourTable.[Ble service] = "TTO" OR YourTable.[Ble service] = "OPPO"; You used [Ble service] and [Bble service] and that is probably why it ask you to enter a response. -- Build a little, test a little. "Eva" wrote: > Hi > I have two querries that are the same, except I have the criteria: > - on column called Ble service - one query asks for items "TTO" the other > for "OPPO" > When I try to union both queries into one using sql (union all) then on the > result the query asks for bble service - I can just type enter and have the > result of the query, but I want to skip it - I just want to click to my union > query and see the results. > I am doing something wrong that it asks me for it? > Thank you > > -- > Greatly appreciated > Eva
From: KenSheridan via AccessMonster.com on 22 Dec 2009 13:00 Eva: If it is prompting for "bble service" could this be a typo in the query for "Ble service", which you say is the column name. But, if both parts are the same apart from the criteria on the column why do you need a UNION ALL operation at all for this? Can't it be done with: SELECT * FROM [YourTable] WHERE [Ble service] = "TTO" OR [Ble service] = "OPPO"; Ken Sheridan Stafford, England Eva wrote: >Hi >I have two querries that are the same, except I have the criteria: >- on column called Ble service - one query asks for items "TTO" the other >for "OPPO" >When I try to union both queries into one using sql (union all) then on the >result the query asks for bble service - I can just type enter and have the >result of the query, but I want to skip it - I just want to click to my union >query and see the results. >I am doing something wrong that it asks me for it? >Thank you > -- Message posted via http://www.accessmonster.com
From: Eva on 22 Dec 2009 13:25 Hi Karl Thank you for your response. I have in both column called Ble service (there was a typo), and I tried your suggestion and I got the syntax error message. If I have two queries I don't need union to join them as one? (the reason I have two queries that headings are the same is that the information presented there is different so I coudn't do it in one query) -- Greatly appreciated Eva "KARL DEWEY" wrote: > If I understand correctly you do not need a union. > Try this -- > SELECT YourTable.* > FROM YourTable > WHERE YourTable.[Ble service] = "TTO" OR YourTable.[Ble service] = "OPPO"; > > You used [Ble service] and [Bble service] and that is probably why it ask > you to enter a response. > > -- > Build a little, test a little. > > > "Eva" wrote: > > > Hi > > I have two querries that are the same, except I have the criteria: > > - on column called Ble service - one query asks for items "TTO" the other > > for "OPPO" > > When I try to union both queries into one using sql (union all) then on the > > result the query asks for bble service - I can just type enter and have the > > result of the query, but I want to skip it - I just want to click to my union > > query and see the results. > > I am doing something wrong that it asks me for it? > > Thank you > > > > -- > > Greatly appreciated > > Eva
From: Eva on 22 Dec 2009 13:58
It works now! thanks both of you ! -- Greatly appreciated Eva "KenSheridan via AccessMonster.com" wrote: > Eva: > > If it is prompting for "bble service" could this be a typo in the query for > "Ble service", which you say is the column name. > > But, if both parts are the same apart from the criteria on the column why do > you need a UNION ALL operation at all for this? Can't it be done with: > > SELECT * > FROM [YourTable] > WHERE [Ble service] = "TTO" > OR [Ble service] = "OPPO"; > > Ken Sheridan > Stafford, England > > Eva wrote: > >Hi > >I have two querries that are the same, except I have the criteria: > >- on column called Ble service - one query asks for items "TTO" the other > >for "OPPO" > >When I try to union both queries into one using sql (union all) then on the > >result the query asks for bble service - I can just type enter and have the > >result of the query, but I want to skip it - I just want to click to my union > >query and see the results. > >I am doing something wrong that it asks me for it? > >Thank you > > > > -- > Message posted via http://www.accessmonster.com > > . > |