daily pastebin goal
52%
SHARE
TWEET

Untitled

a guest Feb 22nd, 2019 57 Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  1. SELECT da.account_name, da.account_id, da.status, da.manager_firstname,
  2. dap.live_password_change, dap.dev_password_change FROM dba_account da INNER JOIN
  3. dba_account_password dap ON da.account_id = dap.account_id
  4.    
  5. SELECT da.account_name,
  6.     da.account_id,
  7.     da.status,
  8.     da.manager_firstname,
  9.     dap.live_password_change,
  10.     dap.dev_password_change
  11. FROM dba_account da
  12. LEFT JOIN dba_account_password dap
  13.     ON da.account_id = dap.account_id
  14.    
  15. SELECT da.account_name, da.account_id, da.status, da.manager_firstname,
  16. dap.live_password_change, dap.dev_password_change FROM dba_account da LEFT JOIN
  17. dba_account_password dap ON da.account_id = dap.account_id
  18.    
  19. table 1
  20. userid  username
  21. 1        ABC
  22. 2        PQR
  23. 3        DEF
  24. table2
  25. userid  userRole
  26. 1       ACCOUNTANT
  27. 2       HO
  28.  
  29. RESULT OF LEFT JOIN :-
  30.  
  31.  left join on table1.userid=table2.userid
  32.     userid   username  userrole
  33.     1        ABC        ACCOUNTANT
  34.     2        PQR        HO
  35.     3        DEF
  36.  
  37. **
RAW Paste Data
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy. OK, I Understand
 
Top