Restrictions on Consume Mode SELECT Requests
The following restrictions apply to SELECT AND CONSUME TOP 1 requests (see SQL Data Manipulation Language for details).
The workaround for this is to perform an INSERT … SELECT operation to copy the rows from the queue table you want to join with another table into a non‑queue table, then join that non‑queue table with the other table.
DELETE ALL FROM tempTbl;
INSERT INTO tempTbl
SELECT AND CONSUME TOP 1 * FROM qTbl;
SELECT c.name, t.customerId, t.orderId
FROM tempTbl AS t, customer AS c
WHERE t.customerId = c.customerId;
You cannot specify a SELECT AND CONSUME request in any of the following.