In a DBMS featuring subqueries, this is easy: SELECT sent_id, subs_id FROM sent AS outer_sent WHERE sent_id = ( SELECT sent_id FROM sent WHERE subs_id = outer_sent.subs_id ORDER BY date_created DESC ...

The CONNECTION TO component specifies the DBMS connection that you want to use or that you want to establish (if you have omitted the CONNECT statement). CONNECTION TO then enables you to retrieve ...

You must specify a DBMS-SQL-query argument in the CONNECTION TO component, and the query must be enclosed in parentheses. The query is passed to the DBMS exactly as you type it; therefore, if your ...