3 rows where authors_id = 10866248

View and edit SQL

Link authors_id books_id
Scott Alexander 10866248 Asches to Asches 26111676
Scott Alexander 10866248 It Was You Who Made My Blue Eyes Blue 27394352
Scott Alexander 10866248 Ars Longa, Vita Brevis 41018921

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