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.

   FROM Artist
   JOIN Album_Artist ON Album_Artist.artist_id =
   JOIN Album ON = Album_Artist.album_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?

Learn how Oracle Real Application Clusters (RAC) One Node allows customers
to consolidate database storage, standardize their database environment, and, 
should the need arise, upgrade to a full multi-node Oracle RAC database 
without downtime or disruption
libdbi-users mailing list

Reply via email to