I would like to select all medicines some have the 'MMAP' property and some dont. If a medicine has the MMAP property then the medicines product code will apear in the MMAP table.

there are also other properties like MMAP which the medicine may have but located in different tables....

my current statement brings up nothing...

rsProductList.Open "SELECT med.[Product Name] & ' ' & med.
[Presentation Code] & ' ' & med.Dosage & ' ' & med.[Dosage
Description] & ' ' & med.Volume & ' ' & med.[Volume Description] AS ProductInfo, med.[Nappi Code - First Six Digits] & med.[Nappi
Suffix - Last Three Digits] AS NappiCode, man.[Manufacturer
Name], med.*, mmap.[MMAP pack price exl vat] FROM MED007
med LEFT JOIN Mma007 mmap ON mmap.[Medprax product code] = med.[Unique Medprax Product Code], Mnf002 man WHERE med.
[Manufacturer Code] = man.[Manufacturer Code] ORDER BY med.
[Product Name]", gconnMedAidBrowser, adOpenKeyset,
adLockOptimistic

is there a problem with my join.

i havent really done joins before.

in the end i would like a list of all the medicines and for each the MMAP column may or may not contain a value