Win a copy of The Little Book of Impediments (e-book only) this week in the Agile and Other Processes forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

Problem in Executing Join Query in Access

 
devayani Devasthali
Ranch Hand
Posts: 40
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hi,
I have written one query using right Join. That works fine on MYSQL but does not work on Access. getting error as Join expression not supported.
can Anydbody explains it to me what does it mean?
and how to write right join in access?
(Right join syntanx is -
select * from Table1 right join table2 on condition )
is the above syntax is correct?


thanx & regards
Devayani
 
David O'Meara
Rancher
Posts: 13459
Android Eclipse IDE Ubuntu
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
"devayani",
Please see the previous requests to fix your display name here and here.

Display names must be two words: your first name, a space, then your last name, fictitious names are not allowed.

This is your last warning. If you do not fix your display name immediately, your account will be deleted.

thanks,
Dave
 
Wei Dai
Ranch Hand
Posts: 86
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
MS Access should support INNER JOIN,LEFT JOIN and RIGHT JOIN. Check your ON expression.
 
Mr. C Lamont Gilbert
Ranch Hand
Posts: 1170
Eclipse IDE Hibernate Ubuntu
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
You mean Microsoft Jet database engine? it not that full featured. in any event make sure you create the right database type when you create one. if you create the older version it supports even less.
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic