I am following the lessons in Sams Teach Yourself SQL in 10 Minutes using MySQL as the databse app. I am having some trouble with Lesson 7: Creating Calculated Fields where you are suppose to concatenate several fields.
The Input looks like this:
SELECT vend_city+', '+vend_state+' '+vend_zip FROM Vendors ORDER BY vend_name;
The output should look like this:
--------------------------------------------------------------- Anytown , OH 44333 Bear Town , MI 44444 Dollsville , CA 99999 New York , NY 11111 London , N16 6PS Paris , 45678
The output that I get is this:
+-----------------------------------------+ | vend_city+', '+vend_state+', '+vend_zip | +-----------------------------------------+ | 44333 | | 44444 | | 99999 | | NULL | | 11111 | | NULL | +-----------------------------------------+
According to the text:
The solution is to concatenate the three columns. In SQL SELECT statements, you can concatenate columns using a special operator. Depending on what DBMS you are using, this can be a plus sign (+) or two pipes (||).
Neither seem to work.
Can anyone point me in the right direction?
Thanks.
Gilbert Wilson
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
