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 Westi on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

JetSQL statement query

Status
Not open for further replies.

daggers

Technical User
Sep 10, 2002
13
GB
Hi,

If I have the following code in a SQL statement in MS Query:

...WHERE table_x.variable_y='A'
GROUP BY table_x.variable_z....

and run it, it appears to ignore the first line and groups the entire content of table_x rather than grouping the content of table_x and restricting the grouped content to where variable_y='A'. Is there any way of doing this?

Thanks.
 
JetSQL is usually used for MS Access and not for MS SQL Server. If you are using MS Access or something else besides SQL Server you need to post in the appropriate forum.

If this is for SQL Server, I apologize, but I'm not familiar with JetSQL.

-SQLBill
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top