Don't like ads? PRO users don't see any ads ;-)
Public Pastes
Guest

Untitled

By: a guest on Apr 26th, 2012  |  syntax: SQL  |  size: 0.30 KB  |  hits: 22  |  expires: Never
download  |  raw  |  embed  |  report abuse  |  print
Text below is selected. Please press Ctrl+C to copy to your clipboard. (⌘+C on Mac)
  1. SELECT
  2.     p.id,
  3.     p.meno,
  4.     p.priezvisko,
  5.     -- popripade ine stlpce
  6.     d.kod,
  7.     d.nazov
  8. FROM pacient p
  9. JOIN pacient_has_poistovna pd ON pd.pacient_id = p.pacient_id
  10. JOIN def_poistovna d ON pd.id = d.id
  11. WHERE
  12.     p.id = 1
  13.     AND p.aktualna = 1 -- tymto obmedzis ze vytiahnes len aktualnu
create a new version of this paste RAW Paste Data