How to fetch related source and destination Flights from table

Hi My table consists of:

source  destination
LA  BOS
LA  BOS
Seattle BOS
Bos LA
BOS Seattle
NY  Seattle
CA  LA
LA  CA
LA  Chicago
CA  BOS
BOS Seattle

​x
 
source  destinationLA  BOSLA  BOSSeattle BOSBos LABOS SeattleNY  SeattleCA  LALA  CALA  ChicagoCA  BOSBOS Seattle​

I am trying to fetch if my source either contains boston or seattle and if either my destination contains boston or seattle. so result should look like this:

source  destination
Seattle BOS
BOS Seattle
BOS Seattle

 
source  destinationSeattle BOSBOS SeattleBOS Seattle​

My query does not work:

select source,destination 
from dbo.flights
where source in ('BOS','Seattle') or destination in('BOS','Seattle')

 
select source,destination from dbo.flightswhere source in ('BOS','Seattle') or destination in('BOS','Seattle')​

Answer

As @jarlh said in a comment, use AND instead of OR:

select source,
       destination 
from   dbo.flights
where  source      in ('BOS','Seattle')
AND    destination in ('BOS','Seattle')

 
select source,       destination from   dbo.flightswhere  source      in ('BOS','Seattle')AND    destination in ('BOS','Seattle')​

Advertisement

Answer