eldan88 Posted February 22, 2014 Share Posted February 22, 2014 Hey guys! I am getting into mysql aliasing, and have tried to run a query on the following code below. Its only showing the Address field as "80" When it needs to show 80-20 188st. The city and Country is also not showing for some reason. Below is the SQL statement I am trying to use. SELECT CustomerName, Address+', '+City+', '+Country AS Address FROM sandbox; Attached is my table structure I created through HEIDI SQL,along with the row data and redsult query. Any help would be really appreciated!!! Quote Link to comment https://forums.phpfreaks.com/topic/286427-sql-aliasing/ Share on other sites More sharing options...
Barand Posted February 22, 2014 Share Posted February 22, 2014 you need to use the CONCAT() function to concatenate fields, not + Quote Link to comment https://forums.phpfreaks.com/topic/286427-sql-aliasing/#findComment-1470117 Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.