new to SQL-help

[ymeyaw]

hi ,Good day. I had a problem when selecting data from a table which look like this:source targeta ba cb ab cwhat basic SQL statement i should use inorder to :1) select data with two ways define in the table , with result like this:source target (2 ways) a b b a2) select data with only one way define in the table, with result look like this:source target (1 way) a c b cThanks in advance....