Complicated sql query with 3 one to many tables.
Posted on 2004-08-05
I have 3 tables.
What I want is a select query that will return the age of the children in one column and their heights at these ages in the next columns. So something like:
Age Martin Steve Johan
1 0.4 0.5 0.6
2 0.6 0.7 0.7
3 1.0 1.2 1.15
So I dont mind building a query for each parent and I need to be able to handle upto 9 children so I dont need an exponentially complicated query.