/SQL/Bus source and destination equal to destination and source of another by sql query

Bus source and destination equal to destination and source of another by sql query

select b.bus_no, b.bus_name,s1.source,s1.destination
from buses b, schedule s1, schedule s2
where b.bus_no=s1.bus_no and s1.source=s2.destination
and s2.source=s1.destination and s1.bus_no!=s2.bus_no
order by bus_no;

Source: stackoverflow.com

Similar codes

7 votes286 views1 answer
Query delete duplicates
SQL
1 vote288 views1 answer
How refresh navicat tables to see new tables
SQL
0 vote308 views1 answer
Mysql where in keep order
SQL
0 vote311 views1 answer
Change magento database url usimg musql
SQL
0 vote298 views1 answer
How to get data between a last week in mysql
SQL
0 vote256 views1 answer
Connection error in mysql workbench
SQL
0 vote332 views1 answer
Joomla execute raw sql
SQL
0 vote306 views1 answer
Get sum sqlite android
SQL
2 votes308 views2 answers
Maximum execution time of 360 seconds exceeded
SQL
0 vote305 views2 answers
Auto increment column in mysql query results
SQL