How to use inner join to get more records in sql server?

Question

Hi Team

I am using join to query record lists, results do populate on one record(Transaction Code only and need others like DateTime Passed. I cant amend my query to get more where clause on one query and need some help. Meaning is there a way in sql query where clause can be used to get more results? However my DateTime Passed record is not showing and need some help as well.

// sql query // sql query

select
     [Station Description]
     [Transaction Code]
 from [Tracking_Server_DB].[dbo].TS_Station as stn
 inner join [Tracking_Server_DB].[dbo].[Checkpoint Movement] as mv
     on stn.[Transaction Code]  = mv.[Transaction Code]
 where stn.[Station Description] IN ('T0011', 'M250', 'T0011')
 order by [DateTime Passed] desc

Dinesh D · Answer

Solution 2 select [Station Description] [ Transaction Code] [DateTime Passed] from [Tracking_Server_DB].[dbo].TS_Station as stn inner join [Tracking_Server_DB].[dbo].[ Checkpoint Movement] as mv on stn.[ Transaction Code] = mv.[ Transaction Code] where stn.[Station Description] IN ( 'T0011'  'M250'  'T0011' ) --and [DateTime Passed]~Condition order by [DateTime Passed] desc

Dinesh D · Answer

Solution 1 if you want all columns select * from [Tracking_Server_DB].[dbo].TS_Station as stn inner join [Tracking_Server_DB].[dbo].[ Checkpoint Movement] as mv on stn.[ Transaction Code] = mv.[ Transaction Code] where stn.[Station Description] IN ( 'T0011'  'M250'  'T0011' ) order by [DateTime Passed] desc

Guest User · Answer

Hi Dinesh Last question on my query on where clause e.g where stn.[Station Description] IN ('M100' 'R800' 'R400' 'M250' 'LBP8'). It filters only M250 where is there are some records for data like R800 how can i pass this? In another words on my where clause it must filter if there is a data available. What am i missing? Meaning it returns 2 records and ignores others like R800 R400 etc

Guest User · Answer

Hi Dinesh Ok I want 3 records not all the logic is working