ay, December 10, 2003 2:42 PM
> To: [EMAIL PROTECTED]
> Subject: SQL Tutorial Trouble in MySQL
>
>
> Hi all,
>
> 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
> SELECT vend_city+', '+vend_state+' '+vend_zip
> FROM Vendors
> ORDER BY vend_name;
SELECT
CONCAT( vend_city, ', ', vend_state, ' ', vend_zip )
FROM
Vendors
ORDER BY
vend_name
> The solution is to concatenate the three columns. In SQL SELECT
> statements, you can concatenate columns usi
Hi all,
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+' '+