partial implementation of join
progress implementing join
use real field names