Hopefully someone a little more solid in SQL can give me a hand.
I have a many-to-many-to-many setup.
a.field1
a.field2
a.field3
x.afield1
x.bfield1
b.field1
b.field2
b.field3
y.bfield1
y.cfield1
c.field1
c.field2
c.field3
In essence, I need all a.field1 where c.field3="stringvalue".
I could do it with multiple queries, and looping, but I am hoping there is a simpler, single query I can make.
Thanks in advance for any help.