Personal, I have the following 3 tables ...
Table: Author
Matricula - Name_Autor - CPF - Address - DATE_NASCIATION - Nationality
Table : Author_livro
COD_LIVRO - Enroll
Table: Book
COD_LIVRO TITLE PROCO LANCATION Subject cod_edit
My doubt is as follows:
A command that returns the name of the authors and the titles of the books of his own. List by author name order.
Thanks
Help with SELECT! (Join between tables)
-
- Moderador
- Posts: 2016
- Joined: Wed, 12 Jan 2005 3:25 pm
- Location: Araraquara - SP
Abraço,
Trevisolli
OCA Oracle PL/SQL Developer Certified Associate
OCP Oracle Forms Developer Certified Professional
Araraquara-SP
Trevisolli
OCA Oracle PL/SQL Developer Certified Associate
OCP Oracle Forms Developer Certified Professional
Araraquara-SP
Brother,
Testa, check if I have not forgotten:
Whatever, send it there.
Testa, check if I have not forgotten:
SELECT M.NOME_AUTOR,
L.TITULO
FROM MATRICULA M,
AUTOR_LIVRO A,
LIVRO L
WHERE M.MATRICULA = A.MATRICULA
AND L.COD_LIVRO = A.COD_LIVRO
ORDER BY M.NOME_AUTOR;
-
- Moderador
- Posts: 2016
- Joined: Wed, 12 Jan 2005 3:25 pm
- Location: Araraquara - SP
Abraço,
Trevisolli
OCA Oracle PL/SQL Developer Certified Associate
OCP Oracle Forms Developer Certified Professional
Araraquara-SP
Trevisolli
OCA Oracle PL/SQL Developer Certified Associate
OCP Oracle Forms Developer Certified Professional
Araraquara-SP
Imagine Brother ...
can help, we are there.
can help, we are there.
-
- Information
-
Who is online
Users browsing this forum: No registered users and 2 guests