Sql Query needed for documents assigned to a scan queue

[Sharon_Weber1]

I would like to create a query that lists which scan queues contain a specific document type.  Looking at the database mrg and the tables using sql server management studio, I'm having a difficult time finding the right tables columns.  Any suggestions will be appreciated. 

[Anthony_Boyd]

 Hi Sharon,

This should do it:

SELECT hsi.scanqueue.queuename, hsi.doctype.itemtypename

FROM hsi.doctype INNER JOIN

hsi.scanqueuexit ON hsi.doctype.itemtypenum = hsi.scanqueuexit.itemtypenum INNER JOIN

hsi.scanqueue ON hsi.scanqueuexit.queuenum = hsi.scanqueue.queuenum

ORDER BY hsi.scanqueue.queuename, hsi.doctype.itemtypename

Thanks

Anthony

[Sharon_Weber1]

That worked perfectly!  Thanks!