This is a complicated (to me at least) query that I need to get done.
Here is what I have:
{Table1}
ID, Xavg, Yavg,Zavg
{Table2}
ID, A, B, C, Xn, Yn, Zn
What I need is a query that looks at record where:
Table1.ID = Table2.A OR Table2.B OR Table2.C
It then averages the Xn, Yn, and Zn of...