Hi

I hava a table (well) and a view (plate_view), for plate_view with pid = 1, there are supposed to be only 20 records, each of reach correponds to a record from the "well" table based on the well id. The well table has 96 different records with different well id.

When I do a full outer join like following, why is it that I can only see 20 reocrds ? Shouldn't I expect to see 20 records and 76 records with null values appear for the 76 well records that cannot be found from the view of plate_view ?

select a.well, b. b.content, b.well,
from well_def a full outer join
plate_view b
on a.well_id = b.well_id
where b.pid = 1 ;