LEFT JOIN sql query

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

From: "Michael Malinsky" <mikemalin@xxxxxxxxxxx>
Date: 26 Aug 2005 18:23:34 -0700

I am trying to populate a listbox from an access database using a left
join based on the value in a combobox. So if the ComboBox1.ListIndex1
= 1 then I want to retreive those records where FK = 1. My statement
is as follows:

statement = "SELECT tblPageLines.LineNum from tblPageLines LEFT JOIN
tblPages ON tblPageLines.FKPages = " & cbPages.ListIndex + 1

I am getting runtime error -2147217900 (80040e14): Join expression not
supported.

Do I have a syntax problem or is there something more?

Thanks,
Mike.

.

Follow-Ups:
- Re: LEFT JOIN sql query
  - From: Rob Bovey

Prev by Date: Re: Opening a list of workbooks
Next by Date: Re: get name of sheets
Previous by thread: protect cells
Next by thread: Re: LEFT JOIN sql query
Index(es):
- Date
- Thread