Multiple Subquery joins on same table

[jghouse]

Everyone,

I am just starting my work with subqueries and I am a little lost on how to handle the syntax on one part.

I have a query that will contain some subqueries for the purpose of counting the records in three different tables.

I understand how to create the subqueries for the most part but I am unsure how to set-up the join since all 3 subqueries will need to join back to the same table that also has to be joined to one other table not in any of the subqueries.

Basically each table (lets say tbl1, tbl2, and tbl3) has the field "Item" that will need to be counted and joined to tblItems.Item.

How do I got about setting up the syntax on those joins? I know how to make them individually but not all the in the same query.

An example of what one of the queries looks like follows:

SELECT tblItems.Item, Count(Q.Item) AS KanbanInHold
FROM [SELECT tblKanbanInHold.Item
FROM tblKanbanInHold INNER JOIN tblItems ON tblKanbanInHold.Item = tblItems.Item]. AS Q INNER JOIN tblItems ON Q.Item = tblItems.Item
GROUP BY tblItems.Item;

Thanks

[aas4mis]

The inner join syntax will only join items that are matching. If you have different items your joins are doing nothing. I don't have access in front of me but I believe you want a UNION or possibly a LEFT join.