-
help with joining table and view
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 ;
Tags for this Thread
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
|