foreign key & join.