I have a query below...each table has the common element of Document_id, however the LINE_ITEMS_TABLE can have multiple rows in it. As such my results set is coming back larger than expected. How can have the query just pull one row from the LINE_ITEMS_TABLE?
SELECT <LIST Of VALUES>
FROM WORKFLOW_TABLE A,
WHERE A.QUEUE = 1
AND A.USER = 'MSMITH'
AND B.ORGID = '123'
AND A.DOCUMENT_ID = B.DOCUMENT_ID
AND C.COMPANY = '01'
AND C.DOCUMENT_ID = A.DOCUMENT_ID