Views--one-to-many

[rgw]

My views work fine if I'm working with tables that don't have a one-to-many relationship but I run into trouble when I have the following:

I have a check file (parent) which will have a single record for check '111111'. The child table may have several detail records. Different transactions but all combined into check '111111'.
The view will only seem to change the field in the first child record and leaves subsequent one unaltered. What should I be looking out for here?

many thanks
rgw

 

[jesylv]

The stated behaviour is quite normal. Your view combines selected parent table columns with selected child columns. Now depending on the JOIN clause (INNER, FULL, OUTER) you will get either one record (parent + first child record) or n records (where n is the number of child records) In the later case the parent columns are repeated for each child record. I suspect you use a clause that produced only one record thus the noted behaviour.

Hope this is helpfull.

Jean