Question

postgresql 中多表查询 （将两个查询语句整成一条查询语句）

select "U_ID","U_UserName","U_UserPwd","U_UserType","U_UserTel","O_ID" from "tb_UserInfo"

select "E_ID","E_Date","E_Remark","U_ID" from "tb_EngMainInfo"

Answer 1

select A."U_ID",A."U_UserName",A."U_UserPwd",A."U_UserType",A."U_UserTel",A."O_ID",
B."E_ID",B."E_Date",B."E_Remark"
from "tb_UserInfo" A,"tb_EngMainInfo" B
Where A."U_ID" = B,"U_ID"