Hi All, Has anyone noticed this? Try this query select tbl_name from sqlite_master group by tbl_name
Now try this query select tbl_name from (select * from sqlite_master) group by tbl_name The same results should be displayed but only one row is displayed. This also affects group by when using a view Can any one confim this for me Greg
