Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- SELECT q.Question
- FROM `Capri_Autopath_Questions` q
- INNER JOIN `Capri_Autopath_Flow` f on f.Hid = 2 AND f.Sid = 2
- WHERE q.Qid = f.Qid
- LIMIT 10
- Fid INT(255) PRIMARY_KEY AUTO_INCREMENT,
- Qid INT(255)
- Rid INT(255)
- Sid INT(255)
- Hid INT(255)
- Type VARCHAR(1)
- Qid INT(255) PRIMARY_KEY AUTO_INCREMENT
- Title VARCHAR(120)
- SELECT s.Title, h.Title, s.Sid, h.Hid
- FROM `Capri_Autopath_Users` u
- INNER JOIN `Capri_Autopath_Specialty` s ON u.Sid = s.Sid
- INNER JOIN `Capri_Autopath_Hospitals` h ON u.Hid = h.Hid
- WHERE u.Uid = '1'
- LIMIT 1
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement