(Part 1) Database Programming

SQLite Client: Joining Tables 31 SQL and SQLite [see slide] When joining tables you can specify the columns/fields that you want in the result table If (and only if) a field name x appears in both tables, then you must qualify the field name with the table name You can join more than two tables. SELECT * from books, orders WHERE books.isbn = orders.isbn; Aside: Joining Tables Warning 32 No row ... ................
................