authors_books

3 rows where authors_id = "alexandre-dumas"

✎ View and edit SQL

This data as json, CSV (advanced)

Link authors_id books_id
alexandre-dumas,alexandre-dumas/the-count-of-monte-cristo Alexandre Dumas alexandre-dumas The Count of Monte Cristo alexandre-dumas/the-count-of-monte-cristo
alexandre-dumas,alexandre-dumas/the-last-cavalier Alexandre Dumas alexandre-dumas The Last Cavalier: Being the Adventures of Count Sainte-Hermine in the Age of Napoleon alexandre-dumas/the-last-cavalier
alexandre-dumas,alexandre-dumas/the-three-musketeers Alexandre Dumas alexandre-dumas The Three Musketeers alexandre-dumas/the-three-musketeers

Advanced export

JSON shape: default, array, newline-delimited, object

CSV options: 

CREATE TABLE [authors_books] (
   [authors_id] TEXT REFERENCES [authors]([id]),
   [books_id] TEXT REFERENCES [books]([id]),
   PRIMARY KEY ([authors_id], [books_id])
);