MySQL Forums
Forum List  »  Newbie

Re: Need help Building mysql query to count specific data under same table/row
Posted by: Peter Brawley
Date: September 28, 2016 10:18AM

To join two queries using a common column x ...

select ...
from (1st qry) as a
join (2nd qry) as b using(x);

to_char() is not a mysql function. Why is it required here? '25-SEP' is not a valid mysql date value. What DBMS are you using?

Options: ReplyQuote




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.