Advertisement
Guest User

Untitled

a guest
Oct 27th, 2016
63
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.53 KB | None | 0 0
  1. SELECT q.Question
  2. FROM `Capri_Autopath_Questions` q
  3. INNER JOIN `Capri_Autopath_Flow` f on f.Hid = 2 AND f.Sid = 2
  4. WHERE q.Qid = f.Qid
  5. LIMIT 10
  6.  
  7. Fid INT(255) PRIMARY_KEY AUTO_INCREMENT,
  8. Qid INT(255)
  9. Rid INT(255)
  10. Sid INT(255)
  11. Hid INT(255)
  12. Type VARCHAR(1)
  13.  
  14. Qid INT(255) PRIMARY_KEY AUTO_INCREMENT
  15. Title VARCHAR(120)
  16.  
  17. SELECT s.Title, h.Title, s.Sid, h.Hid
  18. FROM `Capri_Autopath_Users` u
  19. INNER JOIN `Capri_Autopath_Specialty` s ON u.Sid = s.Sid
  20. INNER JOIN `Capri_Autopath_Hospitals` h ON u.Hid = h.Hid
  21. WHERE u.Uid = '1'
  22. LIMIT 1
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement