It's an outer join statement used for oracle databases, so i guess it wouldn't work after all, seeing as I'm using Access. However, I tried converting it to the ANSI JOIN format, and I'm still having problems:
sqlString = "SELECT C.Course_code, C.Course_title, COUNT(O.Course_code) AS Attendees...
Hi,
I'm trying to run an outer join, and while the SQL query works outside VB 2005, when used in VB 2005 it's a completely different story. It's really frustrating - it's like Microsoft has decided that they want people to write SQL queries in a different way that normal. Here's the query...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.