Re: [libdbi-users] sqlite3 multiple tables

2011-02-20 Thread markus . hoenicka
[Vikram's original mail from 2010-12-25 got lost from my inbox, so I have to apologize for (1) being darn late and for (2) not keeping the thread intact] > 1. Artist (id,name) > 2. Album (id,VA,name) > 3. Album_Artist (artist_id,album_id) [...] > no tables in statement ! > no tables in statem

[libdbi-users] sqlite3 multiple tables

2010-12-24 Thread Vikram Ambrose
Seem to be having a small problem with the sqlite3 driver. Scenario is 3 tables. 1. Artist (id,name) 2. Album (id,VA,name) 3. Album_Artist (artist_id,album_id) (VA = is a flag to denote Various Artists type Albums) Trying to select a particular Artist from a list VA=0 Albums. SELECT Artist.id