i tried few things from documentaion but its not working
here is my query
SELECT notification.*,event.title,user.firstname,user.lastname FROM notification
LEFT JOIN event ON event.id = notification.source_id
AND notification.activity_type = "checkin"
LEFT JOIN user ON user.id = notification.source_id
AND notification.activity_type = "friend"
and here is the query i write for now,i need to add AND function just like its in the query
$query->select
([
'[color=#008800][size=2]notification.* As Not,event.title As Event,user.firstname As First,user.lastname As Last[/size][/color][size=2]'[/size]
])
->from('[size=2]notification[/size][size=2]')[/size]
->join('LEFT OUTER JOIN','event','[size=2]notification[/size][color=#666600][size=2].[/size][/color][size=2]source_id[/size][size=2]=[/size][color="#000088"][size=2]event[/size][/color][color=#666600][size=2].[/size][/color][size=2]id[/size][size=2]')[/size]