Re: SQL statement to read previous records

On 18-May-2016 15:14 -0500, Darren Strong wrote:

On 18-May-2016 11:18 -0500, CRPence wrote:

[Some of] What has been offered so far, seems to limit the result
to just one previous main-record. Or perhaps intending to suggest
that one could obtain some maximum\constant number of main-records,
but then apparently a result-set inclusive of main-records from
prior\unrelated attr-records.? I do not recall any that returned
only\all-of the previous main-records for a given attr-record.

This is taking passive writing style to an insane level. What I
think you're saying, is that the solutions so far have not allowed
for more than one main record, or that it might pull a record that
was not the correct main record. My answer to that is that the OP
defined the issue as one main record, and that the attributes always
followed the main record. Since there is no key or tie to the main
record, we have to follow the rules as they were stated, and assume
that the first previous main record found will be the correct one.

I was just about to post a correction to that. So this serves that purpose.

I had not gone back to review the OP, instead having looked back to a post showing a query as the "statement to retrieve the attribute record". That had me misconstruing the original message, because that followup message with the query seemed to suggest that there were two main-records for one attribute-record; the replies I recalled would find main-record for any attribute-record, which in hindsight, makes perfect sense for the use of the term "main" :-Q