Seems like mysql full join is not working between two sub queries, here is query I have tried. I may not post my actual query, but here is the model where it gives idea about how I tried and my requirement.
select * from (select * from campaign) a full join (select * from usagecount)b using(user_id);
Where it works for
select * from campaign full join usagecount using(user_id);
My question is that, if it(full join) works when I use between two normal table why it won't work between subqueries.
