I want to add attributes from a lot area that contains a building. What is the right function ? Are there any examples ? create table bldgplus as ( select b.id, b.name, l.type from building b ???? left join lot l on l ???? where contains(l,b) ); thanks for any help