full join two select statement

Asked Apr 01 '16 at 06:04

Active Dec 10 '18 at 05:29

Viewed 47 times

what's wrong with this code, both sub select statement work well but full join give me error

select t1.*, t2.*
from (
    SELECT
        `users-transaction`.`users-transaction-id` as 'id-1',
     concat(`users-transaction`.`users-transaction-year`+ `users-transaction`.`users-transaction-month`+ `users-transaction`.`users-transaction-day`) as date1,
        sum(`users-transaction`.`users-transaction-price`) as gharzi
    FROM `users-transaction` 
    where  `users-transaction`.`users-transaction-type`=0 
        GROUP BY `users-transaction-year`, `users-transaction-month`, `users-transaction-day`
    ) t1
    full outer JOIN
   (

    SELECT  
        `users-transaction`.`users-transaction-id` as 'id-2',
     concat(`users-transaction`.`users-transaction-year`+ `users-transaction`.`users-transaction-month`+ `users-transaction`.`users-transaction-day`) as date2,
        sum(`users-transaction`.`users-transaction-price`) as pardakhti
    FROM `users-transaction` 
    where  `users-transaction`.`users-transaction-type`=1 
        GROUP BY `users-transaction-year`, `users-transaction-month`, `users-transaction-day`
    ) t2 on t1.date1=t2.date2

Table structure:

edited Dec 10 '18 at 05:29

Cœur

37,241
25
195
267

asked Apr 01 '16 at 06:04

Buddha

1

`FULL JOIN` is not available in MySQL – Giorgos Betsos Apr 01 '16 at 06:05
i want merge two table into one how i can do this – Buddha Apr 01 '16 at 06:14
Give your table structure – anas p a Apr 01 '16 at 06:16
We have Union All for full outer join https://dev.mysql.com/worklog/task/?id=1604 – Rahul Vyas Apr 01 '16 at 06:30

full join two select statement

0 Answers0