SQL SHOW one more column name FROM operator in

Question

我需要显示来自 IN 的列 运算符
我的查询是:

    SELECT prizes.type,prizes.name
       FROM  lottery_payment_prizes payment
         JOIN lottery_prizes prizes ON 
          prizes.id =  payment.prize_id 
     WHERE payment.payment_id IN
       (( SELECT id FROM lottery_payments 
      WHERE  lottery_id = (SELECT id FROM lotteries WHERE abbr = 'TR' AND group_id = '3' )))

结果是:

我的问题:如何显示 lottery_payments 中的两列，lottery_payments 只返回 ID 给 IN 运算符

函数。
我需要显示 lottery_payemnts 表中的列名称“place”。
谢谢大家。

Answer 1

如果您需要来自 lottery_payments 的列，您需要向其添加一个连接:

SELECT payments.place, payments.id, prizes.type, prizes.name
   FROM  lottery_payment_prizes payment
     JOIN lottery_prizes prizes ON 
      prizes.id =  payment.prize_id 
     JOIN lottery_payments payments ON 
      payment.payment_id =  payments.id 
 WHERE lottery_id = (SELECT id FROM lotteries WHERE abbr = 'TR' AND group_id = '3' )