Posted by MC on 10/01/71 11:19
You need to join those two tables. Then you can filter them on condition(s)
you need. This would be one way of doing it, please specifiy structure and
expected result if this isnt good enough:
select ColumnList --- list of columns you need returned
from
Family f
inner join FamilyMembers fm on f.PK_Family = fm.PK_Family
where
fm.Age > 16
--- PK_Family is Primary Key on Family table
MC
"RichMUK" <support@insurance.uk.com> wrote in message
news:1119522354.673863.165840@g49g2000cwa.googlegroups.com...
> This is probably straight forward, but let's see:
>
> Say I have a Family which includes an address field table and a related
> FamilyMembers table which includes an age field.
>
> I need to output a report on each Family where there is at least one
> family member with an age over 16.
>
> Any help gratefully received!
>
[Back to original message]
|