Hi All,
I have two table, In first table I have user web activity details which has login and logout date & time columns. If there is a logout time in column that means user is inactive otherwise Active.
Now I have a second table which has all details of user like name, mobile, email, address.
Also I have user_id column in both table which is could be our join to get the data in both the table, so we want some Active user information based on attachment details, if user is active than his/her details should be captured in the table. Please advise.