Help with Select! (join between tables)

[Mr.Paulo]

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

[Trevisolli]

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.

[Mr.Paulo]

You é good huh man!!!

It worked!

Thanks

[Trevisolli]

Imagine brother ...
Being able to help, we are there.