Help with a SQL query

[Ed_Prunier]

I am very new to SQL and trying to learn my way around the tables.  I'd like to retrieve a list of all document types from select document groups and show show which scan queue they belong to.  The problem I'm having with my query is that no row is returned if the document type is not assigned to a scan queue.  I'd like to see a blank entry.  

SELECT dt.itemtypenum AS "Document ID", dt.itemtypename AS "Document Type", itg.itemtypegroupname
AS "Document Type Group", sq.queuename AS "Scan Queue"
FROM hsi.doctype dt
INNER JOIN hsi.itemtypegroup itg ON dt.itemtypegroupnum = itg.itemtypegroupnum
INNER JOIN hsi.scanqueuexit si ON dt.itemtypenum = si.itemtypenum
INNER JOIN hsi.scanqueue sq ON sq.queuenum = si.queuenum
WHERE dt.itemtypenum > 100
AND dt.itemtypegroupnum IN (102,104,111,112)
ORDER BY "Document Type"

[Ed_Prunier]

Thank you Mike. I appreciate the info.

[John_Szefcyk]

Ed,

Here's a little more info you can pull back!

SELECT
dt.itemtypenum AS "Document ID",
RTRIM(itg.itemtypegroupname) AS "Document Type Group",
RTRIM(dt.itemtypename) AS "Document Type",
ISNULL(RTRIM(sq.queuename),'<>') AS "Scan Queue",
ISNULL(RTRIM(dg.diskgroupname),'') AS "Scan Queue DG",
ISNULL(RTRIM(pp.lastuseddrive),'') AS "Current Location"
FROM
hsi.doctype dt WITH(NOLOCK)
JOIN hsi.itemtypegroup itg WITH(NOLOCK) ON dt.itemtypegroupnum = itg.itemtypegroupnum
LEFT JOIN hsi.scanqueuexit si WITH(NOLOCK) ON dt.itemtypenum = si.itemtypenum
LEFT JOIN hsi.scanqueue sq WITH(NOLOCK) ON sq.queuenum = si.queuenum
LEFT JOIN hsi.diskgroup dg WITH(NOLOCK) ON sq.diskgroupnum = dg.diskgroupnum
LEFT JOIN hsi.physicalplatter pp WITH(NOLOCK) ON sq.diskgroupnum = pp.diskgroupnum AND dg.lastlogicalplatter = pp.logicalplatternum
WHERE
dt.itemtypenum > 100
AND dt.itemtypegroupnum IN (102,104,111,112)
ORDER BY
2,3,4