Answers for "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;

Posted by: Guest on June-06-2021

Code answers related to "bus source and destination equal to destination and source of another by sql query"

Code answers related to "SQL"

Browse Popular Code Answers by Language

Answers for "bus source and destination equal to destination and source of another by sql query"

Code answers related to "bus source and destination equal to destination and source of another by sql query"

Code answers related to "SQL"

Browse Popular Code Answers by Language

Answers for "bus source and destination equal to destination and source of another by sql query"

Code answers related to "bus source and destination equal to destination and source of another by sql query"

Code answers related to "SQL"

Browse Popular Code Answers by Language

Popular Programming Languages

Advertisements

Company

Compilers

Help

Connect with us