mysql - Not able to get data by subQueries (multiple subQueries with no direct relation) -

i want data user_login table contains following fields:

user_login : id, status, date, user_id

in table status can 1 or 2

if status 1 login else logout.

i want login , logout both details in 1 row tried query:

select login.date, logout.date  (select date user_login userid = 1 , status = 1 , date = now()) login,  (select date user_login userid = 1 , status = 2 , date = now()) logout. 

i data when both login , logout has data. want when login has data not logout.

please me in solving prob.

use left join. this:

select login.date, logout.date       (         select              userid,             date                       user_login userid = 1 , status = 1 , date = now()     )          login left join     (         select              date,             userid                       user_login                      status = 2              , date = now()     ) logout         on logout.userid=login.userid 

or think better solution this:

select     user_login.userid,     max(case when user_login.status=1 date else null end) logindate,     max(case when user_login.status=2 date else null end) logoutdate,     user_login     user_login.userid=1     , date = now() group     user_login.userid