Guest User

Untitled

a guest
Jun 23rd, 2018
78
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.54 KB | None | 0 0
  1. # returns 27 rows
  2. SELECT * FROM hdl_development.Fall WHERE (Fall.Geburtsjahr LIKE('19%'))
  3.  
  4. # returns over 13k rows
  5. SELECT DISTINCT * FROM hdl_development.Fall
  6. LEFT JOIN Entgelte ON Entgelte.KH_internes_Kennzeichen = Fall.KH_internes_Kennzeichen
  7. LEFT JOIN FAB ON FAB.KH_internes_Kennzeichen = Fall.KH_internes_Kennzeichen
  8. LEFT JOIN ICD ON ICD.KH_internes_Kennzeichen = Fall.KH_internes_Kennzeichen
  9. LEFT JOIN OPS ON OPS.KH_internes_Kennzeichen = Fall.KH_internes_Kennzeichen
  10. WHERE (Fall.Geburtsjahr LIKE('19%'))
Add Comment
Please, Sign In to add comment