This content has been marked as final. Show 2 replies
You don't need to add a concatenated column to a table; rather, you can select two (or more) columns from the table and concatenate them in your SQL. You had the answer, it was just over-engineered.
Simply issue this SQL from the SQL workshop to get what you're looking for:
Hope this help!
SELECT country || roletitle countryrole FROM price_book
- Scott -
Edited by: Scott on Dec 6, 2012 5:52 PM