how to arrange by joining tables

[ld_be]

You must use order by
More information see http://sqlcourse2.com/orderby.html

Example:

SELECT *
FROM customer_info
INNER JOIN purchases
ON customer_info.customer_number = purchases.customer_number
ORDER BY customer_info.firstname, customer_info.lastname;