Combine 2 Select Distinct Queries
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?
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.