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
  

Poston Fri, 08 Jun 2007 12:04 am

Guys, I have the following 3 tables.

Table: Author REGISTRATION-Author_name-CPF-ADDRESS-DATA_NASCIMENTO-NATIONALITY table: Autor_livro cod_livro-registration table: COD_LIVRO Book TITLE PRICE RELEASE DATE SUBJECT COD_EDITORA My question is the following: a command that returns the name of the authors and the titles of the books of his own. List in order of author name.

Thank you
Mr.Paulo
Location: Barretos-SP

Poston Fri, 08 Jun 2007 8:11 am

Brother, Testa ai, check to make sure I didn't forget anything:
Code: 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;
 
qualquer thing, says ai.
Trevisolli
Location: Araraquara - SP

Abraço,

Trevisolli
OCA Oracle PL/SQL Developer Certified Associate
OCP Oracle Forms Developer Certified Professional
Araraquara-SP

Poston Fri, 08 Jun 2007 9:24 am

You é good huh man!!!

It worked!

Thanks
Mr.Paulo
Location: Barretos-SP

Poston Fri, 08 Jun 2007 1:12 pm

Imagine brother ...
Being able to help, we are there.
Trevisolli
Location: Araraquara - SP

Abraço,

Trevisolli
OCA Oracle PL/SQL Developer Certified Associate
OCP Oracle Forms Developer Certified Professional
Araraquara-SP


  • See also
    Replies
    Views
    Last Post


Return to SQL

Who is online

Users browsing this forum: No registered users and 2 guests