Welcome to the Treehouse Community

Want to collaborate on code errors? Have bugs you need feedback on? Looking for an extra set of eyes on your latest project? Get support with fellow developers, designers, and programmers of all backgrounds and skill levels here with the Treehouse Community! While you're at it, check out some resources Treehouse students have shared here.

Looking to learn something new?

Treehouse offers a seven day free trial for new students. Get access to thousands of hours of content and join thousands of Treehouse students and alumni in the community today.

Start your free trial

Databases Introducing the Practice

mihran akopyan
PLUS
mihran akopyan
Courses Plus Student 1,904 Points
Posted by mihran akopyan
mihran akopyan
Courses Plus Student 1,904 Points

Select CONCAT("string1", "string2") from table... does not work. am I missing something ?

I am working on the "Practice Column Selection and Aliasing with SQL" Video.

Select CONCAT("string1", "string2") from table

Am I missing something?

3 Answers

KRIS NIKOLAISEN
KRIS NIKOLAISEN
54,971 Points

I don't see Select CONCAT in the video. Are you using SQL playground? If so the db is SQLite and it appears that Select CONCAT is a MySQL function.

mihran akopyan
PLUS
mihran akopyan
Courses Plus Student 1,904 Points
mihran akopyan
mihran akopyan
Courses Plus Student 1,904 Points

I am using the workspace. I was just trying to output address under one column it is the challenge 4.

Christian Higgins
Christian Higgins
15,758 Points
Christian Higgins
Christian Higgins
15,758 Points

Mihran, I see what you're trying to do, but all the information you need to do Challenge 4 is contained in the sales table.