Help with SELECT! (Join between tables)

Dúvidas, dicas e truques de SQL, Select, Update, Delete, cláusulas, operações com joins, Funções em SQLs, etc
Post Reply
Mr.Paulo
Rank: Estagiário Pleno
Rank: Estagiário Pleno
Posts: 7
Joined: Sun, 03 Jun 2007 9:07 pm
Location: Barretos-SP

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
Trevisolli
Moderador
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

Brother,

Testa, check if I have not forgotten:

Select all

 
 
 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; 
   
Whatever, send it there.
Mr.Paulo
Rank: Estagiário Pleno
Rank: Estagiário Pleno
Posts: 7
Joined: Sun, 03 Jun 2007 9:07 pm
Location: Barretos-SP

You're really good, huh, man!

worked out!

Thanks
Trevisolli
Moderador
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

Imagine Brother ...
can help, we are there.
Post Reply
  • Information
  • Who is online

    Users browsing this forum: No registered users and 2 guests