my table employee contains id,firstname,lastname.
i want to display the table as id fullname
100 ram kumar
200 karan kumar
means name field contains fullname and below fullname there is lname and fname
how it is possible