I'm working with a table which holds versions of vacancies...
It has fields:
vacID (char16, which is a FK)
and others which are not relevant
For each vacID, there will be 1 or many rows, each with a seperate dateCreated.
However, I only want to return the latest row (ie. semantically the current version of the vacancy), for each vacancy.
I *can* edit the table to include a ROWID (a pk) field if needs be, but would like to see both options if possible - with ROWID and without ROWID.
how do I do this?