>Thanks, Edward.
can also do
>SELECT DISTINCT B.name, B.address,;
> B.postalcode, B.built, B.floors,;
> B.location, B.class, etc. ;
> FROM cpi!agents INNER JOIN cpi!buildings B ;
> ON Agents.contactid = B.lpmcoid;
> etc.
also -- should have at least one space between end of line and semi-colon. (don't remember why, read that somewhere)