Raizekas

Untitled

Apr 15th, 2021
608
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  1. SELECT a.adresas
  2. FROM adresas a
  3. INNER JOIN adr_klient_sujungimas s
  4. ON s.kliento_id = 1 AND a.id = s.adreso_id;
  5.  
  6.  
  7. SELECT *
  8. FROM klientas k, adresas a
  9. WHERE k.id = 1 AND a.id = 1;
  10.  
  11. SELECT adreso_id
  12. FROM adr_klient_sujungimas
  13. WHERE kliento_id = 1;
  14.  
  15. SELECT *
  16. FROM klientas
  17. WHERE id = 1;
  18.  
  19. SELECT *
  20. FROM adresas;
  21.  
  22. SELECT *
  23. FROM adr_klient_sujungimas;
  24.  
  25. SELECT *
  26. FROM klientas;
  27.  
  28. SELECT id, pavarde, vardas
  29. FROM klientas
  30. WHERE id = 3;
  31.  
  32. SELECT id, pavarde, vardas
  33. FROM klientas
  34. WHERE id = 5;
RAW Paste Data