I have 2 tables individuals and families...
im trying to create a query that lists all the families and extract the names of the members of the families associated with the family
thus i have created the following query
The results of this query come out like this....SELECT family.FAMID, family.Married, individual.FName, individual.MName, individual.LName FROM quesnel_marriages AS family, quesnel_individuals AS individual WHERE individual.INDID = family.Husband OR individual.INDID = family.Wife ORDER BY family.Married, individual.Born ASC
Is there any way to group the results into a class field1 209 1960-06-24 Vincent Edmund Quesnel
2 209 1960-06-24 Ulusia Joan Henderson De Lyon
IDeas are greatly appreciated1 209 1960-06-24 Vincent Edmund Quesnel Ulusia Joan Henderson De Lyon
Kendall
[/quote]