Is it possible to join these both tables?

1 vote

2 answers

23 views

                              SELECT u.*,h.*,d.* 
    FROM User u
    LEFT JOIN HealthDec h ON u.ID = h.EmpId
    LEFT JOIN Document d On u.ID = d.UserID;

and:

    SELECT count(id) FROM OHS 
    WHERE Category = 'POLICIES' 
      AND ID NOT IN 
      (
        SELECT OHSID 
        FROM User_OHS 
        WHERE UserID='1' AND Type='POLICIES'
      );


Both queries are working fine separately as required. But I want to combine both queries to get result for each user.



                        

Asked by pankaj (13 rep)

Mar 15, 2021, 06:16 PM
Last activity: Mar 15, 2021, 06:38 PM

Is it possible to join these both tables?

Related Questions