RE: ... should be a simple query question ...

[McCollough, Alan]

That's called a 'nested Select'. Ya can't do it in Access. Either that or
I'm wrong again.

Anyhow y'all would be wise to hop over to www.swynk.com , there are some
serious SQL gurus over there...

Alan McCollough
Web Programmer
Allaire Certified ColdFusion Developer
Alaska Native Medical Center

> -----Original Message-----
> From: Jeffrey Marsh [SMTP:[EMAIL PROTECTED]]
> Sent: Tuesday, October 24, 2000 8:18 AM
> To:   Fusebox
> Subject:      RE: ... should be a simple query question ...
> 
> How come you have the SELECT statement in the WHERE clause surrounded by
> parenthesis without an AND conjunction? Does this query work from within
> Access?
        {redacted uh huh...}
------------------------------------------------------------------------------
To Unsubscribe visit 
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/fusebox or send a 
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.