Interface was tested using a blank LIMSSUPER database (Oracle 8i) structure. There are two basic queries available based on source configuration based on the "Import based on Approval date from" on the advanced settings tab in Configuration - Source Configuration.

Using Orders Table approval date field (ORDERS.APPRDATE):

SELECT ORDERS.ORDNO, ORDERS.SAMPDATE, ORDERS.SAMPTIME, ORDERS.APPRDATE, ORDERS.SAMPNAM,  RESULTS.ANALYTE, RESULTS.QUAL, RESULTS.FINALQ , RESULTS.UNITS, RESULTS.APRDATE, RESULTS.METHODNO, ORDERS.COMPTIM, ORDERS.COMPTYPE, RESULTS.COMMENTS, ORDERS.SAMPLEDBY, ORDERS.SAMPLENO, ORDERS.SAMPNUM, RESULTS.ANALDATE, RESULTS.ANALTIME, RESULTS.ANALYST
FROM ORDERS, RESULTS 
WHERE ORDERS.ORDNO = RESULTS.ORDNO AND ORDERS.APPRDATE>= & dtStringStart &  AND ORDERS.APPRDATE< & dtStringEnd
AND ORDERS.DELFLAG IS NULL AND ORDERS.SAMPNAM IS NOT NULL AND RESULTS.ANALYTE IS NOT NULL and RESULTS.FINALQ is not null
AND ORDERS.SAMPDATE IS NOT NULL AND ORDERS.SAMPTIME IS NOT NULL

Using Results Table approval date field (RESULTS.APRDATE):

SELECT ORDERS.ORDNO, ORDERS.SAMPDATE, ORDERS.SAMPTIME, ORDERS.APPRDATE, ORDERS.SAMPNAM,  RESULTS.ANALYTE, RESULTS.QUAL, RESULTS.FINALQ , RESULTS.UNITS, RESULTS.APRDATE, RESULTS.METHODNO, ORDERS.COMPTIM, ORDERS.COMPTYPE, RESULTS.COMMENTS, ORDERS.SAMPLEDBY, ORDERS.SAMPLENO, ORDERS.SAMPNUM, RESULTS.ANALDATE, RESULTS.ANALTIME, RESULTS.ANALYST
FROM ORDERS, RESULTS
WHERE ORDERS.ORDNO = RESULTS.ORDNO AND RESULTS.APRDATE>= & dtStringStart &  AND RESULTS.APRDATE< & dtStringEnd
AND ORDERS.DELFLAG IS NULL AND ORDERS.SAMPNAM IS NOT NULL AND RESULTS.ANALYTE IS NOT NULL and RESULTS.FINALQ is not null
AND ORDERS.SAMPDATE IS NOT NULL AND ORDERS.SAMPTIME IS NOT NULL