i got a problem in executing the two different tables ...
for eg take those two tables given in the tutorial
http://sqlcourse2.com/joins.html

i want to display the complete table with firstname lastname, ordered_date, items, price etc in ascending order of names ie. firstname...
but when i do that i only list out differently...
please guide....