Posted on: 5/27/2013 9:03:40 PM | Views : 401

I have some difficulty during report creation and the data display show from tables itself are "LABUAN" AND "SABAH".  I want this 2 states of LABUAN group as SABAH.   But, of course, the quantity for the Month - JANUARY will carry forward base on the figure from LABUAN will group into "SABAH". 
For example ;
STATE         QUANTITY
SABAH             1000
LABUAN             500
I  want the state "LABUAN" will group as 'SABAH' .  Instead the Quantity will group into 1 as well.
Can this works from the query ?   I have try out using the UNION ALL, but, it doesn't work.  Can you please assist what kind of query I should use.

Thank you.
...

Go to the complete details ...