Hi all, I have something like: Class User id
Class Group id Class Membership id group fk user fk type char1 Class Message id group fk user fk I'm a little confused about how to do this join from the django db api: select message.* from message, membership where message.group_id = membership.group_id AND message.user_id = membership.user_id AND membership.type <> 'B' I basically want all the messages where the related membership type is not 'B'... any help would be much appreciated --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "Django users" group. To post to this group, send email to django-users@googlegroups.com To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/django-users?hl=en -~----------~----~----~----~------~----~------~--~---