SQL Embedded Sub-Query
Posted on 2016-07-29
I have my main query and I need an additional sub-query I need to embed.
I currently have this query in Access that needs to be a sub-query and return the oldest TRANS_DATE for the conditions listed
SELECT FINAN.FILENO, FINAN.TRANS_DATE
FROM FINAN INNER JOIN MASTER ON FINAN.FILENO = MASTER.FILENO
WHERE (((FINAN.CODE) Between "19" And "23" Or (FINAN.CODE)="2") AND ((FINAN.BPJ)="J") AND ((FINAN.TRUST)="TR53") AND ((FINAN.AMOUNT)>0) AND ((MASTER.JMT_DATE)<[TRANS_DATE]));
I also have a second query in Access that finds the MIN date for each FILENO and returns it to the query.
So, in plain English...
FINAN and MASTER tables link with FILENO
I need the oldest TRANS_DATE when the WHERE statement above is true
Thanks in advance...