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.idNow 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.
------------------------------------------------------------------------------ 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 http://p.sf.net/sfu/oracle-sfdevnl
_______________________________________________ libdbi-users mailing list libdbi-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/libdbi-users