order by using another table's order

[bjswift]

I have two temp tables populated with data from a stored procedure. I can get one table in a certain order, based on sales data (descending/ascending), but would like to order the other table in the exact same order. Both tables have storeID as a similar column, and didn't know if I could write the order by using another table's order properties?

Thanks!

[bjswift]

This always happens to me.. Post a question here, take a step back, and find a solution that works. I just basically joined the tables and had the same order by clause as the first table. However, isn't joining the tables make the processing slower? I didn't really notice a huge difference, but maybe if my tables were a lot larger it would. If there is a better way to order one table using another table's order by, without joining, please explain. Thanks!