SELECT  a.userGroupID, a.userID, a.fname, a.lname,
        b.order_ID,user_ID,purchase_amount,purchase_date
        c.opt-in,c.user_ID
FROM    Users a
        INNER JOIN Orders b
            ON a.userID = b.orderlD
        WHERE purchase_date = 'true'
        INNER JOIN Permissions c
            ON b.userID = c.userID
        WHERE opt-in = 'true';