Access denies query start with linked table?

Question

I have 3 tables each, as follows

cash_credit

Bank_Name-------in_date-------Com_Id---Amount
America Bank    15/05/2010      1       200
HSBC            17/05/2010      3       500

Cheque_credit
Bank_Name-----Cheque_Number-----in_date-------Com_Id---Amount
America Bank   74835435-5435    15/05/2010      2       600
HSBC           41415454-2851    17/05/2010      5       100

Companies
com_id----Com_Name
1         Ebay
2         Google
3         Facebook
4         Amazon

Company table is a related table when I tried to create a query by following

SELECT cash_credit.Amount, Companies.Com_Name, cheque_credit.Amount
FROM cheque_credit INNER JOIN (cash_credit INNER JOIN Companies ON cash_credit.com_id = Companies.com_id) ON cheque_credit.com_id = Companies.com_id;

I get an error that my internal connection is wrong, this request was created using the Access 2007 query design error

Type mismatch in expression

then I thought that it could be an internal join, so I tried Left Join and I get an error that this method is not used

JOIN expression is not supported

I am confused where is the problem causing it all

Answer 1

com_Id / ?
, .

.

Answer 2

, :

SELECT cash_credit.Amount, Companies.Com_Name, cheque_credit.Amount
FROM ( cheque_credit
INNER JOIN Companies 
ON cheque_credit.com_id = Companies.com_id)
INNER JOIN  cash_credit
ON cash_credit.com_id = Companies.com_id;

Answer 3

:

, , - , . , , . , , :

Companies.com_id
cash_credit.com_id
cheque_credit.com_id

, , , , :

LEFT JOIN INNER JOIN, , :

• LEFT JOIN: NULL
• INNER JOIN: