Join 3 tables in SQLite database
I have 3 tables in SQLite database:

**Songs:**

    _id | name | length | artist_id (foreign key) | album_id (foreign key)

**Artists:**

    _id | name

**Albums:**

    _id | name

I need a query (use it in an Android app) of a table that consists of the following columns:

    _id | name | length | artist_id | artist_name | album_id | album_name

However, I write the following query statement:

    SELECT Songs._id, Songs.name, Songs.length, Songs.artist_id, Artists.name, Songs.album_id, Albums.name FROM Songs, Artists, Albums WHERE Songs.artist_id = Artists._id AND Songs.album_id = Albums._id

but it gives me an empty table. I tried `OR` instead of `AND` and it gives incorrect results (every song duplicates in each album, though the artist is correct). How can I fix my query statement to join the 3 tables in a single table?
Join 3 tables in SQLite database
===

I have 3 tables in SQLite database:

**Songs:**

    _id | name | length | artist_id (foreign key) | album_id (foreign key)

**Artists:**

    _id | name

**Albums:**

    _id | name

I need a query (use it in an Android app) of a table that consists of the following columns:

    _id | name | length | artist_id | artist_name | album_id | album_name

However, I write the following query statement:

    SELECT Songs._id, Songs.name, Songs.length, Songs.artist_id, Artists.name, Songs.album_id, Albums.name FROM Songs, Artists, Albums WHERE Songs.artist_id = Artists._id AND Songs.album_id = Albums._id

but it gives me an empty table. I tried `OR` instead of `AND` and it gives incorrect results (every song duplicates in each album, though the artist is correct). How can I fix my query statement to join the 3 tables in a single table?