Inner Join - - Computer Learning Zone


	Back to Access Search Seminar Comments List

Upload Images @Reply Bookmark Link Email Next Unseen

Inner Join

Joseph O'Malley

5 years ago

Hi I am just having a few issues joining my tables when writing the SQL = portion of the code. I am trying to inner join 3 tables which correspond to the data I want in the list box.

Any help would be greatly appreciated.

SQL= Select ..... 'the fields from the 3 tables I want'
From (Legal INNER JOIN Record ON Legal.LegalID) INNER JOIN [TESTING] ON Record.Scenario Where ' wh

DoCmd.OpenForm "SearchForm"
SResults.RowSource = SQL

	Joseph O'Malley OP @Reply 5 years ago
Right now the whole "From" portion is highlighted in red with some kind of error

	Adam Schwanz @Reply 5 years ago
I haven't done much with the inner joins so may be way off, but this doesn't look right to me: Where ' wh I think you need a "&" there. SQL = "SELECT PartID, PartNum, Vendor FROM PartsT WHERE " & Wh PartList.RowSource = SQL

	Richard Rost @Reply 5 years ago
A join should have an equality in it: `SELECT CustomerT.CustomerID, OrderT.OrderID FROM CustomerT INNER JOIN OrderT WHERE CustomerT.CustomerID = OrderT.CustomerID` See SQL Seminar

This thread is now CLOSED. If you wish to comment, start a NEW discussion in Access Search Seminar.

Next Unseen

New Feature: Comment Live View