Cosmin Iuga2,352 Points
Does this one make more sense? SELECT street||", "|| city|| ", "|| state||", "|| zip||". "|| country AS "address" FROM addresses;
Thank you again.
Ian HawePro Student 8,494 Points
Hi Hopefully this makes things clear,
SELECT is usually followed by your column names
AS is used to create a name for that column in the results
FROM is used to select from a table.
That being said if the table name is 'addresses' and the column names are 'street||"' '|| city|| "' '"|| state||"' and '"|| zip||". "||' then you're fine. If its not try to find the column names in the table 'address' to present your results. Here is an example of what I think you might be looking for:
SELECT street AS Street, city AS City, state AS State, zip AS Zip FROM addresses;
Tommy Gebru30,148 Points
Just a friendly reminder Cosmin, try not to juggle multiple conversations in the Community Forum
If you don't get an answer immediately try reading and searching for the same questions through the search bar or the filter by subject dropdown