Yoko Posted June 20, 2013 Share Posted June 20, 2013 Hello, I just started to learn SQL on this site. Today I'm learning about "Aliase" chapter on this site.I have a question about this sample SQL. The sample says"In the following SQL statement we combine four columns (Address, City, PostalCode, and Country) and create an alias named "Address" <The chapter>http://www.w3schools...l/sql_alias.asp <The sample>http://www.w3schools...t_alias_column2 I thought four columns would be combined.But it seems to display only PostalCode as Address. Could you tell me the answer of the SQL? Thank you for reading this! Yoko from Tokyo Link to comment Share on other sites More sharing options...
niche Posted June 20, 2013 Share Posted June 20, 2013 The four columns are combined, but delimited with commas. Link to comment Share on other sites More sharing options...
Yoko Posted June 20, 2013 Author Share Posted June 20, 2013 Thank you for your reply, niche! I found the answer.The address isn't displayed correctly on Google Chrome!!If you use Google Chrome, you see only PostalCode as address. I tried to use IE then the address was displayed correctly. Yes, four columns are combined! Thanks, again Link to comment Share on other sites More sharing options...
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now