What is wrong with this query

[zhuanyi]

Hello,
I have a Query that I wrote as follows:

SELECT [TableA].[FieldA], [TableA].[FieldB], TableB.FieldC
FROM [TableA],TableB
RIGHT JOIN [TableA] ON [TableA].[FieldB] = TableB.[FieldD]
GROUP BY [TableA].[FieldA], [TableA].[FieldB], TableB.FieldC;

What happened was that TableA has Fields A and B, and Table B has a field C and D. Tables B and D have the same content (Not necessary unique) and I would like to see a mapping from Field A -> Field C by joining on Field B and D.

However, when I ran it, I got an "invalid arguement" error.

Could anyone help? Thanks a lot!


Regards,
Anyi

 

[zhuanyi]

Never mind, the problem was that my Access database was over the 2GB limit, not because of the query itself.

Thanks!