I have a question about the snippet below. I'm wondering, if the first query doesn't bring any results, would I still get the results for the second query?

select *
from
(
  -- first query
) as query1
left join
(
  -- second query
) as query2
on query1.id=query2.id
left join
(
  -- third query
) as query3
on query1.id=query3.id;

Update:

what I need is a full join, however, MySQL does not support it, what would be a good way to emulate this?