Reply to Re: Beginners Question

Your name:

Reply:


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]


Удаленная работа для программистов  •  Как заработать на Google AdSense  •  England, UK  •  статьи на английском  •  PHP MySQL CMS Apache Oscommerce  •  Online Business Knowledge Base  •  DVD MP3 AVI MP4 players codecs conversion help
Home  •  Search  •  Site Map  •  Set as Homepage  •  Add to Favourites

Copyright © 2005-2006 Powered by Custom PHP Programming

Сайт изготовлен в Студии Валентина Петручека
изготовление и поддержка веб-сайтов, разработка программного обеспечения, поисковая оптимизация