Access is a beginner, I do a stock checking database meet with difficulties,
Two table
Stock: this table is a stock list
Record: this table is to record every day of the stock checking

Hope to do a query, the purpose is to choose each stock the latest a record, at the same time meet the stock. The Open is yes
the condition of
If mysql appears to be using limit, similar to the following

Name SELECT stocks. Open, stock, stock, stock, stock code, recording. The recording time, record. Analysis, record. Note that records.
operationThe FROM stock INNER JOIN records ON stock. ID=record. Stock ID
The WHERE (((. Open)=Yes))
Record. Of the ORDER BY DESC time limit 1;

But the access does not support limit, for help

CodePudding user response:

Top keywords?