how to merge two or more tables sorted according to date [closed]

Question

hello pls i need help on my school project. I have tables try1 and try2, i want to join the two showing the income and expenditure sorted with the date accordingly from the try1 and try2

try1
         +------+-------+--------+--------+
         |  id  | date  | name   |expensis|
         +------+-------+--------+--------+
         |  1   |17/11/1|  shoe  |   200  |
         +------+-------+--------+--------+
         |  2   |17/11/2|  books |   300  |
         +------+-------+--------+--------+
         |  3   |17/11/2| T.fair |   400  |
         +------+-------+--------+--------+

try2
         +------+-------+--------+--------+
         |  id  | date  | name   | source |
         +------+-------+--------+--------+
         |  1   |17/11/1|  Dad   |  1000  |
         +------+-------+--------+--------+
         |  2   |17/11/2| uncle  |        |
         +------+-------+--------+--------+
         |  3   |17/11/4|  Bro   | 150    |
         +------+-------+--------+--------+
 

this is how i want my table to look like

   
    RESULT
             +-------+--------+--------+
             | date  |expensis| source |
             +-------+--------+--------+
             |17/11/1|  200   |  1000  |
             +-------+--------+--------+
             |17/11/2|  300   |        |
             +-------+--------+--------+
             |17/11/2|  400   |        |
             +-------+--------+--------+
             |17/11/4|        |  150   |
             +-------+--------+--------+

i tried many codes and it didnt work out this is the code somewhat close to what i want

 
SELECT u.date, b.amount, h.amount
FROM
  (SELECT Date FROM try1 UNION SELECT Date FROM try2) u
  RIGHT JOIN try1 b ON u.Date=b.Date
 RIGHT JOIN try2 h ON u.Date=h.Date

EDIT: ddl and sample data

CREATE TABLE try1 
( id int(2) AUTO_INCREMENT
, date date
, name varchar(10)
, expencis double(10,0)
,     PRIMARY KEY(id) );

CREATE TABLE try2 
( id int(2) AUTO_INCREMENT
, date date
, name varchar(10)
, sourcee int(10)
,     PRIMARY KEY(id) );

INSERT into try1 (date,name,expencis)
VALUES ('2017-11-1','shoe',200)
     , ('2017-11-2','books',300)
     , ('2017-11-2','t.fair',400);

INSERT into try2 (date,name,sourcee)
VALUES ('2017-11-1','dad',1000)
     , ('2017-11-2','uncle',null)
     , ('2017-11-4','bro',null);

Answer 1

Not entirely sure that I understand your problem, but it appears as if you are looking for a FULL OUTER JOIN. I don't think that is supported by MySQL, but you can mimic the result by doing a union between a LEFT OUTER JOIN and a RIGHT OUTER JOIN:

select t1.date, t1.expencis, t2.sourcee 
from try1 t1 
left join try2 t2 
    on t1.date = t2.date 
union 
select t2.date, t1.expencis, t2.sourcee 
from try1 t1 
right join try2 t2 
    on t1.date = t2.date 
order by date

+------------+----------+---------+
| date       | expencis | sourcee |
+------------+----------+---------+
| 2017-11-01 |      200 |    1000 |
| 2017-11-02 |      300 |    NULL |
| 2017-11-02 |      400 |    NULL |
| 2017-11-04 |     NULL |    NULL |
+------------+----------+---------+

Note that order by is applied after union. For future posts, never use ascii tables like above. Provide CREATE TABLE statements and INSERT statements instead. Your question will likely get more attention, and you will get better answers that way.