Advertisement
Guest User

Untitled

a guest
Feb 23rd, 2019
91
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.49 KB | None | 0 0
  1. SELECT paper_id ,symptom_name FROM My_table
  2. WHERE (symptom_name= "" AND symptom_name= "")
  3.  
  4. SELECT paper_id ,symptom_name FROM My_table
  5. WHERE symptom_name IN ("symptom1", "symptom2", "symptom3", "symptom4")
  6.  
  7. paper_symptom_id paper_id symptom_id
  8. (autogenerated) 1 6
  9. (autogenerated) 1 7
  10.  
  11. select s.*
  12. from papers p
  13. inner join paper_symptoms ps
  14. on ps.paper_id = p.paper_id
  15. inner join symptoms s
  16. on s.symptom_id = ps.symptom_id
  17. where p.paper_id = 1
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement