I am collecting data for graph from two different tables. I have previously applied left join but i am getting graph for only bookings.
I wanted it for booking ang visits both. tables are Bookings Table
bookid | uid | dateTime
--------------------------
1 | 2 | 2017-01-20 12:55
and visits table
visitid | dateTime | ip_Address
-----------------------------------------
1 | 2017-01-20 12:55 | 192.168.1.2
my sql query is below
Select a.date,ifnull(a.bookings,0) AS bookings,ifnull(b.visits,0) as visits
from
(
(SELECT DATE( date ) as date , COUNT( booking_id ) AS bookings FROM `booking` GROUP BY DATE( date )) As a
FULL OUTER JOIN
(SELECT DATE(date) as date,COUNT( ip_address ) as visits FROM visit_counter group by DATE(date)) As b
on a.date = b.date
)
WHERE a.date BETWEEN (NOW( ) - INTERVAL 14 DAY) AND NOW( )
ORDER BY a.date ASC
Here Full Outer Join is raising syntax error. Previously i have applied Left Join and It was working.