Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations MikeeOK on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
Help with tricky query.
A query like the one below will give me the correct result. However, needless to say it will be terribly slow. SELECT SUM(Dist) FROM A WHERE A.NodeId > (SELECT MAX(CInner.NodeId) From C AS CInner WHERE CInner.ObsId = COuter.ObsId AND CInner.NodeId < COuter.NodeId) AND A.NodeId <=...- Morrgan
- Post #4
- Forum: Microsoft: Access Queries and JET SQL
-
Help with tricky query.
Hi, You may. :-) Sorry for beeing so illusive. I am working in the transportation business. The purpose is to diagnose and repair a database containing information collected from our veichles.- Morrgan
- Post #3
- Forum: Microsoft: Access Queries and JET SQL
-
Help with tricky query.
Or at least I find it tricky. :-) Assume we have three tables A, B and C. Table A contains a path and the distance for traveling that path: A (PathId, NodeId, Dist (from previous node)) 1, 1, 0 1, 2, 10 1, 3, 5 Table B contains observed data on path level: B (ObsId, PathId) 1, 1 2, 1 Table...- Morrgan
- Thread
- Replies: 3
- Forum: Microsoft: Access Queries and JET SQL
