indianj
October 21st, 2005, 11:06 PM
hi, i was going through SQL exercise and i could not figure it out how to obtain last names and first name displayed in the same column. if you have any idea, please post your comment here.
Write the SQL statement that will obtain the last names, first names and phone numbers of all authors. Last name and first name should be displayed in the same column, separated by a space. That column should have an alias “Name”.
Write the SQL statement that will obtain the last names, first names and phone numbers of all authors. Last name and first name should be displayed in the same column, separated by a space. That column should have an alias “Name”.