access下疯狂的子查询

根据个人：

select *,
(
    select PName
    from Property
    where PID in
    (
        select GPID
        from PropertyEntity
        where GID = UGID
    )
) as PName,
(
    select PModel
    from Property
    where PID in
    (
        select GPID
        from PropertyEntity
        where GID = UGID
    )
) as PModel,
(
    select PCID
    from Property
    where PID in
    (
        select GPID
        from PropertyEntity
        where GID = UGID
    )
) as PCID,
(
    select POverhaulWay
    from Property
    where PID in
    (
        select GPID
        from PropertyEntity
        where GID = UGID
    )
) as POverhaulWay,
(
    select GPrice
    from PropertyEntity
    where GID = UGID
) as GPrice,
(
    select GSN
    from PropertyEntity
    where GID = UGID
) as GSN,
(
    select GIsScraped
    from PropertyEntity
    where GID = UGID
) as GIsScraped
from UsingHis
where UEID =

 

根据部门：

select *,
(
    select PName
    from Property
    where PID in
    (
        select GPID
        from PropertyEntity
        where GID = UGID
    )
) as PName,
(
    select PModel
    from Property
    where PID in
    (
        select GPID
        from PropertyEntity
        where GID = UGID
    )
) as PModel,
(
    select PCID
    from Property
    where PID in
    (
        select GPID
        from PropertyEntity
        where GID = UGID
    )
) as PCID,
(
    select POverhaulWay
    from Property
    where PID in
    (
        select GPID
        from PropertyEntity
        where GID = UGID
    )
) as POverhaulWay,
(
    select GPrice
    from PropertyEntity
    where GID = UGID
) as GPrice,
(
    select GSN
    from PropertyEntity
    where GID = UGID
) as GSN,
(
    select GIsScraped
    from PropertyEntity
    where GID = UGID
) as GIsScraped
from UsingHis
where UEID in
(
    select EID
    from Employe
    where EDID =
)