create view v_authornames as
select authorid, CONCAT(lastname,',',firstname)
from t_authors;
Or replace the middle term in the CONCAT function to whatever you want
to separate it -- ie, ' ' for a space, or just
CONCAT(lastname,firstname) to get output KritzerSheeri.
-Sheeri
On
Hello NG,
I have two tables in my mysql database
created with phpmyadmin:
t_authors:
1 authorid (primary key, auto_increment)
2 lastname
3 firstname
And a table named t_books, fields inside:
t_books:
1 bookid (primary key, auto_increment)
2 authorid (Typ:index, reference to authorid from