地址sql

    sql.append("(select addr.addrName from SYSCA_Addr as addr where 1=1 and addr.addrKind ='1' and addr.addrID = person.homeAddr1) as ihomeAddr1, ").append("\n");
    sql.append("(select addr.addrName from SYSCA_Addr as addr where 1=1 and addr.addrKind ='2' and addr.addrID = person.homeAddr2) as ihomeAddr2, ").append("\n");
    sql.append("(select addr.addrName from SYSCA_Addr as addr where 1=1 and addr.addrKind ='3' and addr.addrID = person.homeAddr3) as ihomeAddr3, ").append("\n");



select addr.addrName from SYSCA_Addr as addr where 1=1 and addr.addrKind ='1' and addr.addrID = person.homeAddr1) as ihomeAddr1, 
select addr.addrName from SYSCA_Addr as addr where 1=1 and addr.addrKind ='2' and addr.addrID = person.homeAddr2) as ihomeAddr2,
select addr.addrName from SYSCA_Addr as addr where 1=1 and addr.addrKind ='3' and addr.addrID = person.homeAddr3) as ihomeAddr3,