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

Guest User

5y948

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

4 Replies

Know the answer? Post it — somebody with the same question will find it here.

Dinesh D5y ago
Accepted 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
+1
Guest User5y ago
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
+1
Guest User5y ago
Hi Dinesh

Ok

I want 3 records not all, the logic is working
+1
Dinesh D5y ago
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
+1