7 rows where authors_id = 1244

View and edit SQL

Link authors_id books_id
Mark Twain 1244 The Diaries of Adam and Eve 108202
Mark Twain 1244 The War Prayer 237050
Mark Twain 1244 The Adventures of Tom Sawyer 24583
Mark Twain 1244 The Adventures of Huckleberry Finn 2956
Mark Twain 1244 The Prince and the Pauper 62446
Mark Twain 1244 The Awful German Language / Die schreckliche deutsche Sprache 8144897
Mark Twain 1244 Joan of Arc 826706

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])
);