9 rows where authors_id = 1077326

View and edit SQL

Link authors_id books_id
J.K. Rowling 1077326 Harry Potter and the Half-Blood Prince 1
J.K. Rowling 1077326 The Casual Vacancy 13497818
J.K. Rowling 1077326 Harry Potter and the Deathly Hallows 136251
J.K. Rowling 1077326 Harry Potter and the Chamber of Secrets 15881
J.K. Rowling 1077326 Harry Potter and the Order of the Phoenix 2
J.K. Rowling 1077326 Harry Potter and the Sorcerer's Stone 3
J.K. Rowling 1077326 The Tales of Beedle the Bard 3950967
J.K. Rowling 1077326 Harry Potter and the Prisoner of Azkaban 5
J.K. Rowling 1077326 Harry Potter and the Goblet of Fire 6

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