Catalogued titles that have copies — DBMS OPPE Question
Catalogued titles that have copies
00:00
Find the ISBN numbers that appear in both the book_catalogue table and the book_copies table — i.e. catalogued books for which at least one physical copy exists. Take ISBN_no from each table and keep only the values common to both.
Return one column: ISBN_no. Order does not matter.
Database schema
primary keyforeign keyarrow points to the referenced columndrag to pan