MySQL Forums
Forum List  »  Newbie

Combine 2 Select Distinct Queries
Posted by: John Gondek
Date: March 26, 2017 11:42AM

SELECT DISTINCT r.rt_num , DATE_FORMAT(t.PUDate,'%Y-%m-%d')
from route r , temp_combo t
right join
(SELECT DISTINCT tc.Route , DATE_FORMAT(tc.PUDate,'%Y-%m-%d')
from temp_combo tc) tc on t.Route = r.rt_num ; -- unknown column r.rt_num

each Select query returns what I want. How can i get them to display side by side?

Options: ReplyQuote


Subject
Written By
Posted
Combine 2 Select Distinct Queries
March 26, 2017 11:42AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.