Union query
in [General]
|
Prev: I need help
Next: send to email
From: Eva on 22 Dec 2009 14:07 I just tested it and it doesn't work the way I wanted. I will explain more about my queries. Both of them have same headings, but the data is organized differently and it depends on the ble service code.For example in both queries there is a column Code 1 -but in one I need to show bble customer under this heading, and on the other one I need to have there bble product. This is why I created both queries and this is why I need to union them. I know it is stupid, but this is the way how it should be done. So when I did what you suggested first I thought that it is fine, but when I run the query I found out that then all data are organized the same, whis is not what I want. -- Greatly appreciated Eva "Eva" wrote: > 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 > > > > . > >
From: KARL DEWEY on 22 Dec 2009 14:56
Post your two queries. -- Build a little, test a little. "Eva" wrote: > I just tested it and it doesn't work the way I wanted. I will explain more > about my queries. Both of them have same headings, but the data is organized > differently and it depends on the ble service code.For example in both > queries there is a column Code 1 -but in one I need to show bble customer > under this heading, and on the other one I need to have there bble product. > This is why I created both queries and this is why I need to union them. I > know it is stupid, but this is the way how it should be done. So when I did > what you suggested first I thought that it is fine, but when I run the query > I found out that then all data are organized the same, whis is not what I > want. > -- > Greatly appreciated > Eva > > > "Eva" wrote: > > > 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 > > > > > > . > > > |