How to pass mutiple city id in sql query

Question

My sql query as follows

select DISTINCT date_TripDate AS TripDate,traveltype.varchar_TravelTypeCode AS TripType,contactss.Value as Mobilenumber,from [OneC_988].[dbo].[988_Details_VehicleRequest] request join [OneC_988].[dbo].[988_Details_VehicleTrip] trip on request.int_VehicleRequestID=trip.int_VehicleRequestID
and int_CityID ='1'

When i run the above query output as follows

Tripdate TripType Mobilenumber int_CityID

26th aug 16 IN 9878778878 1
26th aug 16 IN 9949949990 1
26th aug 16 IN 9878778878 1

i want to pass both INT_CityID 1 and 2 in the above sql query to get output as follows

Tripdate TripType Mobilenumber int_CityID

26th aug 16 IN 9878778878 1
26th aug 16 IN 9949949990 1
26th aug 16 IN 9878778878 1

28th aug 16 IN 9878778878 2
28th aug 16 IN 9949949990 2
28th aug 16 IN 9878778878 2

Vinay Singh · Answer

First make the comma seperated string of city id and pass that value to query select * from citymaster where id in (1234)

Dipika · Answer

select DISTINCT date_TripDate AS TripDatetraveltype.varchar_TravelTypeCode AS TripTypecontactss.Value as Mobilenumberfrom [OneC_988].[dbo].[988_Details_VehicleRequest] request join [OneC_988].[dbo].[988_Details_VehicleTrip] trip on request.int_VehicleRequestID=trip.int_VehicleRequestID and int_CityID in ('1''2')

Midhun T P · Answer

Hi Try this query - select DISTINCT date_TripDate AS TripDatetraveltype.varchar_TravelTypeCode AS TripTypecontactss.Value as Mobilenumberfrom [OneC_988].[dbo].[988_Details_VehicleRequest] request join [OneC_988].[dbo].[988_Details_VehicleTrip] trip on request.int_VehicleRequestID=trip.int_VehicleRequestID and int_CityID in('1''2') order by int_CityID asc