combo box row source query operator

[Guest]

I have a combo box that queries supplier names and their ID's. Here's the row
source:

SELECT tblSupplierNames.txtSupplierName, tblSupplierIDs.txtSupplierID FROM
tblSupplierNames INNER JOIN tblSupplierIDs ON
tblSupplierNames.txtSupplierName = tblSupplierIDs.txtSupplierName GROUP BY
tblSupplierNames.txtSupplierName, tblSupplierIDs.txtSupplierID ORDER BY
tblSupplierNames.txtSupplierName, tblSupplierIDs.txtSupplierID;

Some suppliers do NOT have an ID. What operator(s) do I use for the above so
that the combo box queries all supplier names regardless if they have an ID
or not?

THANKS A BUNCH!

 

[Graeme Richardson]

Hi John,

Modify the query so that your INNER JOIN is a LEFT JOIN:

SELECT tblSupplierNames.txtSupplierName, tblSupplierIDs.txtSupplierID FROM
tblSupplierNames LEFT JOIN tblSupplierIDs ON
tblSupplierNames.txtSupplierName = tblSupplierIDs.txtSupplierName GROUP BY
tblSupplierNames.txtSupplierName, tblSupplierIDs.txtSupplierID ORDER BY
tblSupplierNames.txtSupplierName, tblSupplierIDs.txtSupplierID;


HTH, Graeme

 

[Guest]

Thank you, Graeme! Very simple solution and it works fine. Have a great day!