[libdbi-users] sqlite3 multiple tables

[Vikram A. <noe...@gm...>]

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,Artist.name
    FROM Artist
    JOIN Album_Artist ON Album_Artist.artist_id = Artist.id
    JOIN Album ON Album.id = Album_Artist.album_id
WHERE Album.VA=0 AND Artist.id=54666831121847624
GROUP BY Artist.name,Artist.id

Now the query works fine directly on the sqlite3 console. But when I 
pass it through libdbi I get a message thrown on the console from the 
driver.

no tables in statement !
no tables in statement !


How do I write that query in a manner compatible with libdbi?


Vikram.