Breaking News: Grepper is joining You.com. Read the official announcement!

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

Combative Crocodile answered on June 6, 2021 Popularity 1/10 Helpfulness 1/10

answer 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

Comment

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;

Popularity 1/10 Helpfulness 1/10 Language sql

Source: stackoverflow.com

Tags: bus sql

Link to this answer
Share Copy Link

Contributed on Jun 06 2021

Combative Crocodile

0 Answers Avg Quality 2/10

Continue with Google

By continuing, I agree that I have read and agree to Greppers's Terms of Service and Privacy Policy.

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

Contents

More Related Answers

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

Grepper

Documentation

Social

Legal

Contact

Oops, You will need to install Grepper and log-in to perform this action.