parent child query

[samvb]

Hey All,

I have two tables lets say:


tblparents: parentid,parent name

tblchildren: chilid,parentco de,childname

Now I want the output like this:

Parent A
child 1
child 2
child 3

Parent B
child 1
child 2
child 3

A simple join repeats parents for each child and i was hoping to avoid that since it required me a lot of check if parent is already added or not...