Web Wiz - Green Windows Web Hosting - Celebrating 25 Years!

  New Posts New Posts RSS Feed - LEFT JOIN on access
  FAQ FAQ  Forum Search   Events   Register Register  Login Login

LEFT JOIN on access

 Post Reply Post Reply
Author
megetron View Drop Down
Groupie
Groupie


Joined: 20 September 2004
Status: Offline
Points: 147
Post Options Post Options   Thanks (0) Thanks(0)   Quote megetron Quote  Post ReplyReply Direct Link To This Post Topic: LEFT JOIN on access
    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
Back to Top
WebWiz-Bruce View Drop Down
Admin Group
Admin Group
Avatar
Web Wiz Developer

Joined: 03 September 2001
Location: Bournemouth
Status: Offline
Points: 9844
Post Options Post Options   Thanks (0) Thanks(0)   Quote WebWiz-Bruce Quote  Post ReplyReply Direct Link To This Post 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.
Back to Top
 Post Reply Post Reply

Forum Jump Forum Permissions View Drop Down

Forum Software by Web Wiz Forums® version 12.08
Copyright ©2001-2026 Web Wiz Ltd.


Become a Fan on Facebook Follow us on X Connect with us on LinkedIn Web Wiz Blogs
About Web Wiz | Contact Web Wiz | Terms & Conditions | Cookies | Privacy Notice

Web Wiz is the trading name of Web Wiz Ltd. Company registration No. 05977755. Registered in England and Wales.
Registered office: Web Wiz Ltd, Unit 18, The Glenmore Centre, Fancy Road, Poole, Dorset, BH12 4FB, UK.

Prices exclude VAT at 20% unless otherwise stated. VAT No. GB988999105 - $, € prices shown as a guideline only.

Copyright ©2001-2026 Web Wiz Ltd. All rights reserved.