Query

P

Prashanta

Actually I am trying out the following query in Access 97
for the Northwind database(default databse in Access)

SELECT [CategoryName] FROM ([Categories] INNER JOIN
(SELECT distinct(CategoryID) FROM [Products]) as T ON
[Categories].[CategoryID] = T.[CategoryID]);

I am getting "Synatx Error in From Clause" as error...

But, the same query is working correctly in Access 2000
databse....Can Any one knows this Why is this happening..
I want to use similar kind of query for my application..


Regards
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

TreeView Query and or Queries Question 4
Access Query - Query Help Is Greatly Appreciated!!!! 5
perform INNER JOIN on query results 2
Cascading combo problem 6
How refer to column of listbox in a query? 2
KB WRONG, for TOP N values per group query. 4
how can i set a variable from an access query to another 2
Help with Duplicate Output Alias Error 'Exp1' 0

Top