6 rows where authors_id = 127314

View and edit SQL

Link authors_id books_id
Otfried Preußler 127314 Neues vom Räuber Hotzenplotz 1148053
Otfried Preußler 127314 Der Räuber Hotzenplotz 1246526
Otfried Preußler 127314 Hotzenplotz 3 1527165
Otfried Preußler 127314 Der kleine Wassermann 292186
Otfried Preußler 127314 The Little Ghost 316808
Otfried Preußler 127314 Krabat 472626

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