SQLite - how to wite a correct join?

Question

Hello.

Sorry for novice question, i have a really limited experience working with SQL :(. I have two tables. First one:

create table history ( id integer primary key, task integer )

And second one:

create table task ( id integer primary key, name text )

What will be an SQLite query that will return a list of history.id and task.name where history.task == task.id ( all items from 'history' table with 'name's from 'task' table )?

Answer 1

Try the following:

SELECT history.id, task.name FROM history LEFT JOIN task ON history.task = task.id

Answer 2

SELECT history.id, task.name
    FROM history
    INNER JOIN task
    WHERE history.task = task.id

Use a LEFT JOIN if you aren't sure that the task will be present for a particular row in history - nulls will be returned if the row is missing.

The syntax for SELECT is described here (using pictures).