Web Wiz Support and Community Forums : LEFT JOIN on access

Web Wiz Support and Community Forums : LEFT JOIN on access https://forums.webwiz.net/ Copyright (c) 2006-2013 Web Wiz Forums - All Rights Reserved. Mon, 13 Apr 2026 08:57:17 +0000 Sun, 05 Feb 2006 17:01:42 +0000 http://blogs.law.harvard.edu/tech/rss Web Wiz Forums 12.08 360 https://forums.webwiz.net/RSS_post_feed.asp?TID=18257 <![CDATA[Web Wiz Support and Community Forums]]> https://forums.webwiz.net/forum_images/web_wiz_forums.png https://forums.webwiz.net/ <![CDATA[LEFT JOIN on access : What is the reason for using a...]]> https://forums.webwiz.net/left-join-on-access_topic18257_post98797.html#98797 Author: WebWiz-Bruce
Subject: 18257
Posted: 05 February 2006 at 5:01pm

What is the reason for using a LEFT JOIN and not a regular join?

One way I find useful to help with the syntax of Access database queries is to use the Query Wizard in Access to make the query, then view this in SQL view and just copy and paste across the SQL code produced by the Wizard.

It's ually not the best SQL code in the world, but it's a quick and simple solution.
]]> Sun, 05 Feb 2006 17:01:42 +0000 https://forums.webwiz.net/left-join-on-access_topic18257_post98797.html#98797 <![CDATA[LEFT JOIN on access : Hi, I am trying to use the left...]]> https://forums.webwiz.net/left-join-on-access_topic18257_post98737.html#98737 Author: megetron
Subject: 18257
Posted: 04 February 2006 at 5:37pm

Hi,

I am trying to use the left join for a specific temporary mod on webwiz 8.0 but I failed use the LEFT JOIN. If I am using the INNER JOIN everything is OK, but I get no desired result.

the error I get is: Join expression not supported.

please help me with the query:

SELECT mainforum.forum_id, mainforum.sub_id, tblForum.Forum_ID, tblForum.Forum_name, tblForum.Sub_ID, tblForum.Password, tblForum.Forum_code, tblTopic.Topic_ID, tblTopic.Poll_ID, tblTopic.Moved_ID, tblTopic.Subject, tblTopic.Icon, tblTopic.Start_Thread_ID, tblTopic.Last_Thread_ID, tblTopic.No_of_replies, tblTopic.No_of_views, tblTopic.Locked, tblTopic.Priority, tblTopic.Hide, tblThread.Message_date, tblThread.Message, tblThread.Author_ID, tblAuthor.Username, LastThread.Message_date, LastThread.Author_ID, LastAuthor.Username
FROM tblCategory, tblTopic, tblThread, tblThread AS LastThread, tblAuthor, tblAuthor AS LastAuthor,
tblForum LEFT JOIN tblforum AS mainforum ON mainforum.Forum_id=tblforum.sub_id
WHERE tblCategory.Cat_ID=tblForum.Cat_ID AND tblCategory.Cat_ID=4 AND tblForum.Forum_ID=tblTopic.Forum_ID AND tblThread.Author_ID=tblAuthor.Author_ID AND LastThread.Author_ID=LastAuthor.Author_ID AND tblTopic.Start_Thread_ID=tblThread.Thread_ID AND tblTopic.Last_Thread_ID=LastThread.Thread_ID AND (tblTopic.Forum_ID IN (SELECT tblPermissions.Forum_ID FROM tblPermissions WHERE (tblPermissions.Group_ID = 1 OR tblPermissions.Author_ID = 1) AND tblPermissions.View_Forum=true))AND (tblTopic.Hide=false OR tblThread.Author_ID=1)
ORDER BY tblForum.Sub_ID, tblForum.Forum_ID, tblCategory.Cat_order, tblForum.Forum_Order, LastThread.Message_date;

Edited by megetron - 04 February 2006 at 5:38pm]]> Sat, 04 Feb 2006 17:37:13 +0000 https://forums.webwiz.net/left-join-on-access_topic18257_post98737.html#98737