Skip to Content
0
Former Member
Dec 03, 2007 at 02:29 PM

How get records with constraint on hierarchical fileds

16 Views

I have table <i>T1</i> with fields <i>F1, F2</i>. <i>F2</i> has reference to the hierarchical table <i>T2</i>. Data in <i>T2</i> organized as:

Parent1

|-Child1

|-Child2

Parent2

|-Child3

I want to get all records from <i>T1</i> which has <i>F2</i> values in Parent1 group.