I have to have a backend program running anyway that inserts data into the database from our units in the field. It also sends text alerts and removes old...

Ok thanks, I am getting closer but still not quite there. Here is what I have now (I have changed company to change by the way):

SELECT Stands.StandID, SPEVersion, LastCallTime,...

Thanks, I tried the first one but now I get this error twice:

Invalid column name 'Version'.

Not sure what you mean by status column is in wrong table.

Thanks for the quick reply.

The type is smallint so I tried your first suggestion but I get the following errors:

Column name 'Karts.Active' is invalid in the ORDER BY clause because...