I have a table that needs to be sorted alphabetically by names that aren't actually contained in the table *in sqlalchemy*. Only codes representing the names are in the table. Like so...
Table 1: row code month value 1 A 201501 50 2 Z 201501 100 3 CO 201501 200 4 VA 201502 300 5 C 201502 300 Table 2: row code name 1 A Apple 2 C Cascade 3 CO Colorado 4 VA Virginia I need to sort *Table 1* the following: - month - name (found in Table 2) What is the best technique to achieve these sorting results when the sorting occurs on value not inherent in the table. I can't send the joined product of Table 1 and Table 2. Although, I can join them temporarily and remove the 'name' column if needed. -- You received this message because you are subscribed to the Google Groups "sqlalchemy" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To post to this group, send email to [email protected]. Visit this group at http://groups.google.com/group/sqlalchemy. For more options, visit https://groups.google.com/d/optout.
