Hello, I don't know if this is even possible is SQL, so please bear with me.... :)
There are a couple a tables (say, a & b) that are used as "logs" for two different processes. They both have the same simple structure. (id, time_stamp, user_id, message) I would like to create a query that merges the data and returns following results: "time_stamp, user_id, a_or_b, message" (where a_or_b is a value that indicates which table the data row came from) Can this be done in SQL/SQLAlchemy. Thank you, :) p.s. Alternatively, the message columns do not need to be merged.... though I guess time_stamp / user would still need to be. That is: "time_stamp, user_id, message_a, message_b" I don't know if that makes any easier... --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "sqlalchemy" group. To post to this group, send email to [email protected] To unsubscribe from this group, send email to [email protected] For more options, visit this group at http://groups.google.com/group/sqlalchemy?hl=en -~----------~----~----~----~------~----~------~--~---
