inner join

[poe]

i have this in access:

 

SELECT INVENTORY.WHSE AS I_WHSE, INVENTORY.CODE AS I_PART_NO, INVENTORY.INV_DESCRIPTION AS I_DESCRIPTION, ck_brand.MASK AS b,  ck_deal.MASK AS d 
FROM INVENTORY
inner JOIN ck_brand ON (INVENTORY.WHSE=ck_brand.I_WHSE) AND (INVENTORY.CODE=ck_brand.I_PART_NO)
inner JOIN ck_deal ON (INVENTORY.WHSE=ck_deal.I_WHSE) AND (INVENTORY.CODE=ck_deal.I_PART_NO);

 

i get this error : syntax error (missing operator) in query expression

 

if i go :

 

SELECT INVENTORY.WHSE AS I_WHSE, INVENTORY.CODE AS I_PART_NO, INVENTORY.INV_DESCRIPTION AS I_DESCRIPTION, ck_brand.MASK AS b
FROM INVENTORY
inner JOIN ck_brand ON (INVENTORY.WHSE=ck_brand.I_WHSE) AND (INVENTORY.CODE=ck_brand.I_PART_NO);

 

everything is ok.

 

problem is i need it to pull from 2 inner join tables (ck_brand AND ck_deal) !

 

[alvin567]

What is the difference between inner join and left join?