fork download
copy 
  1. SELECT clanovi.ime, clanovi.prezime, clanovi.mejl_adresa , datum_uzimanja, knjige.naziv
  2. FROM pozajmice
  3. JOIN clanovi ON clanovi.broj_clanske_karte = pozajmice.broj_clanske_karte
  4. JOIN primerci ON primerci.inventarski_broj = pozajmice.inventarski_broj
  5. JOIN knjige ON knjige.id_knjige = primerci.id_knjige
  6. WHERE datum_vracanja IS NULL
  7. ORDER BY datum_uzimanja
Success #stdin #stdout #stderr 0s 5320KB
comments (?)
stdin
copy 
Standard input is empty
stdout
copy 
Standard output is empty
stderr
copy 
Error: near line 1: no such table: pozajmice
https://ideone.com/LoeXdJ
language:
SQLite (sqlite 3.27.2)
created:
17 hours ago
visibility:
public

Share or Embed source code

Discover > Sphere Engine API

The brand new service which powers Ideone!

Discover > IDE Widget

Widget for compiling and running the source code in a web browser!