On Jun 6, 8:47 am, Michael Bayer <[EMAIL PROTECTED]> wrote: > your "size" column differs in type. you cant create a UNION with > differing types in the unioned queries. so it can either be both > string, both numeric, or use distinct columns.
Ah! Ok, if i was more experienced with unions/joins I would have realized that the way I was doing it, i was asking sa to smash two 'size' columns of different type together. So I can just ask sa to do some column aliasing if I really need the column on each child table to be identically named simply "size", or if I don't mind the change I can switch to having skis have a 'ski_size' column and skiboots have a 'skiboot_size' column, etc. Correct? --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "sqlalchemy" group. To post to this group, send email to sqlalchemy@googlegroups.com 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 -~----------~----~----~----~------~----~------~--~---