Skip to content

Instantly share code, notes, and snippets.

@montogeek

montogeek/gist:ea0d32aea1d7693615fd

Created July 8, 2014 15:52
Show Gist options
  • Save montogeek/ea0d32aea1d7693615fd to your computer and use it in GitHub Desktop.
Save montogeek/ea0d32aea1d7693615fd to your computer and use it in GitHub Desktop.
Download ZIP
Raw
gistfile1.sql
select referencias.titulo, autores.nombre, autores.apellido
from referencias
join autor_referencia on referencias.id = autor_referencia.referencia_id
join autores on autor_referencia.autor_id = autores.id
order by autores.apellido asc
@moscoquera
Copy link

select referencias.titulo, autores.nombre, autores.apellido
from referencias,autor_referencia,autores
where referencias.id = autor_referencia.referencia_id and
autor_referencia.autor_id = autores.id
order by autores.apellido asc

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment