How to build this SQL statement? - (inthane-chan) - (11) - Jan. 13, 2002, 10:27:42 PM EST
         Possible answer, not tested - (drewk) - (5) - Jan. 14, 2002, 10:31:51 AM EST
             That's the real problem... - (inthane-chan) - (2) - Jan. 14, 2002, 01:36:29 PM EST
                 Uh yeah? - (nking) - Jan. 14, 2002, 01:46:48 PM EST
                 I'll try to try it when I get home - (drewk) - Jan. 14, 2002, 03:08:35 PM EST
             Looks right to me - (SpiceWare) - Jan. 14, 2002, 04:19:37 PM EST
             Oughta work in Oracle, anyway, AFAIK. -NT - (CRConrad) - Jan. 14, 2002, 05:39:40 PM EST
         FWIW, I know you can't do that in Access - (tseliot) - (2) - Jan. 14, 2002, 04:28:50 PM EST
             Uh, how about an Access Query based on an Access query? - (nking) - (1) - Jan. 14, 2002, 04:37:45 PM EST
                 That's kinda what I meant by intermediate table - (tseliot) - Jan. 16, 2002, 11:54:30 AM EST
         Here's one way - (rickw) - Jan. 14, 2002, 07:36:48 PM EST
         Subqueries - (ChrisR) - Jan. 15, 2002, 07:23:17 PM EST