libgda 4.0.1 - provider sqlite (i didn't try with other providers) -
sqlite 3.6.16
when i execute this sql
select distinct year from customer
i get n rows per year instead one only
when i execute this sql
select * from customers where exists (select orders.* from orders
where customers.id = orders.id_customers)
i get the error «near "(": syntax error»
both the sql work as i expect if executed inside sqlite console
why? i didn't understand
thanks in advance
_______________________________________________
gnome-db-list mailing list
[email protected]
http://mail.gnome.org/mailman/listinfo/gnome-db-list
