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

Posted by Myra Davis
Myra Davis
2,433 Points

I'm not sure what this question is asking when it say "alias to to_field. This will be "To" field for email_marketing.

I'm not sure what this question is asking when it say "alias to to_field. This will be "To" field for email_marketing. very confused with this question

1 Answer

Matthew Krzyzynski
Matthew Krzyzynski
7,713 Points
Matthew Krzyzynski
Matthew Krzyzynski
7,713 Points

Hi Myra! Yep, the wording is a little tricky here.

Saying "alias to_field" basically means what new name you'll be naming your column when presenting your new data.

In this challenge, it's asking to manipulate the data in such a way where the names and email addresses are presented this way: Andrew Chalkley <andrew@teamtreehouse.com>

The challenge wants the new presentation of the data to be under the column of "to_field."

So once you're done with the concatenating part of the query, you'll want to end the query like this:

AS to_field FROM patrons;

Doing this will make all the new data fall under the new column of "to_field"

I believe you can ignore this sentence as it doesn't seem important to completing this challenge: "This will be 'To' field for email_marketing."