SQL Question - Complex ordering

[Randy Melder]

Why in the world would you insert data already existing in tables into
yet another table? Judging from your requirement, you are not changing
the data in any way, simply gathering it. So why have data in two
places? If you do, you're headed for un-reliability-ville. imho

If you REALLY need to create TEMP data for performance or whatever,
make sure it is in a stored procedure and not application logic.

; ) .randy