8 rows where authors_id = 123715

View and edit SQL

Link authors_id books_id
Agatha Christie 123715 4:50 from Paddington 140278
Agatha Christie 123715 A Murder Is Announced 16298
Agatha Christie 123715 Sleeping Murder 16300
Agatha Christie 123715 Murder on the Orient Express 16304
Agatha Christie 123715 The Body in the Library 16319
Agatha Christie 123715 The Murder of Roger Ackroyd 16328
Agatha Christie 123715 Murder at the Vicarage 16331
Agatha Christie 123715 Nemesis 31304

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