murray83
Games Collector
- Local time
- Today, 18:30
- Joined
- Mar 31, 2017
- Messages
- 728
Can i concatenate
here is my following code
and attached is the output what i wish to do if possible concatenate the LOCATION so it is prefaced with a ;
if i was doing this in excel would be easy but as i am very new to this would like if poss a few pointers
cheers
here is my following code
Code:
SELECT
Location_Id, Qty_Allocated, Qty_On_Hand
FROM
Pick_Face
Where
Qty_Allocated >1 AND Qty_On_Hand <1
ORDER BY Location_Id
and attached is the output what i wish to do if possible concatenate the LOCATION so it is prefaced with a ;
if i was doing this in excel would be easy but as i am very new to this would like if poss a few pointers
cheers
Attachments
Last edited: