在线等待，请帮忙

Question

and (T.employee_name,S.employee_name) in 
                                        (selectemployee_name,manager_name
                                             from MyWork2..manages
                                            )不能样写

Answer 1

那该怎样写呢？我的意思是（T.employee_name,S.employee_name）应该是MyWork2..manages中的元组

Answer 2

分开写 T.employee_name in () and S.employee_name in ()

Answer 3

and (T.employee_name+S.employee_name) in (select employee_name+manager_name from MyWork2..manages)