两张表联合查询,重复字段取一次,即只取第一条
select s.* from
(select LoginUser.UserID,LoginUser.UserName,LoginUser.UserPwd, StationInfo.StationID,StationInfo.StationName,
row_number() over (partition by StationInfo.stationID order by loginuser.userid) as group_idx
from LoginUser,StationInfo where StationInfo.StationID = LoginUser.StationID)s where s.group_idx = 1