I'd strongly recommend to read this:
Visual Representation of SQL Joins[
^]
Quote:
However my DateTime Passed record is not showing and need some help as well.
If you would like to show another column, you have to add it to the list affter
select
statement.
USE [Tracking_Server_DB];
SELECT [Station Description], [Transaction Code], [DateTime Passed]
FROM TS_Station as stn INNER JOIN [Checkpoint Movement] as mv on stn.[Transaction Code] = mv.[Transaction Code]
WHERE stn.[Station Description] IN ('T0011', 'M250', 'T0011')
ORDER BY [DateTime Passed] desc;