A result is currently being returned by a single query, that automatically orders by the posting date.
But now a third party is about to FTP to a second table (several times a week). There has to be a second table, since many postings are made daily and deletions/alterations are made by the party that FTP's to the database.
How can the CURRENT_DATE be split or integrated so the results with dates follow a natural order? This is mysql.
Would it be better to come up with another single query?
A) existing query
(CURRENT_DATE () between query.StartRun and query.EndRun)
😎 third party FTP - seperate table
(CURRENT_DATE () between query2.StartRun and query2.EndRun)
C) existing query
(CURRENT_DATE () between query.StartRun and query.EndRun)
Is this the simplest/best way (following query2 join to query)
(CURRENT_DATE () between (query.StartRun and query2.StartRun) and (query.EndRun and query2.EndRun))
