Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- # returns 27 rows
- SELECT * FROM hdl_development.Fall WHERE (Fall.Geburtsjahr LIKE('19%'))
- # returns over 13k rows
- SELECT DISTINCT * FROM hdl_development.Fall
- LEFT JOIN Entgelte ON Entgelte.KH_internes_Kennzeichen = Fall.KH_internes_Kennzeichen
- LEFT JOIN FAB ON FAB.KH_internes_Kennzeichen = Fall.KH_internes_Kennzeichen
- LEFT JOIN ICD ON ICD.KH_internes_Kennzeichen = Fall.KH_internes_Kennzeichen
- LEFT JOIN OPS ON OPS.KH_internes_Kennzeichen = Fall.KH_internes_Kennzeichen
- WHERE (Fall.Geburtsjahr LIKE('19%'))
Add Comment
Please, Sign In to add comment