SHARE
TWEET

Untitled

a guest May 19th, 2017 38 Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  1. Table A             TABLE B (has fk of A)               TBALE C (HAS FK OF B)
  2. aid aname            bid bname afk                  cid  cname bfk
  3. 1  a                 1   b      1                   1     c     1
  4. 2  a2                2   b2     2                   2     c2     1
  5.  
  6. select a.aname , b.bname , c.cname from A a
  7. left join B b
  8. on a.aid = b.afk
  9. left  join C c
  10. on c.bfk = b.bid;
RAW Paste Data
Pastebin PRO Summer Special!
Get 40% OFF on Pastebin PRO accounts!
Top