django 两表联查

django 两表联查

models.py

class Order(models.Model):order_sn = models.CharField('订单号',max_length=50)user = models.ForeignKey('User',verbose_name='用户')express_sn = models.CharField('快递单号',max_length=50,blank=True)class Order_Good(models.Model):o = models.ForeignKey('Order',verbose_name='订单')g_name = models.CharField('商品名',max_length=50)

views.py

der_press_sn,og.g_name from order o left join order_good og on o.id=og.o_id where o.user_id=5or 
orderGoodList = Order_Good.objects.filter(o__user=5).values_list('o__order_sn','o__express_sn','g_name')