3 rows where authors_id = 108424

View and edit SQL

Link authors_id books_id
Patrick Rothfuss 108424 The Wise Man's Fear 1215032
Patrick Rothfuss 108424 The Name of the Wind 186074
Patrick Rothfuss 108424 The Slow Regard of Silent Things 21535271

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