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!!! 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 + Link to comment https://forums.phpfreaks.com/topic/286427-sql-aliasing/#findComment-1470117 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.