Trouble with "translating" MS SQL View to SQLite view

Hi

As i’m new to SQLite and Xojo i’m asking for little help… Cant get right SQLite view from this MS SQL view…
And help and pointer would be helpful… or example cose i learn best from example :slight_smile:

[code]  SELECT 
        Good_Id, 
        COUNT_BIG(*) AS ProductCount, 
        SUM(ISNULL(Quantity,0)) AS Quantity, Created
  FROM dbo.InventoryItemBases
  where IsDeleted = 0 and Good_Id is not null 
  GROUP BY Good_Id, Created;[/code]

COUNT_BIG is MSSQL only, use COUNT().
ISNULL is IFNULL in SQLite.

SQLite Documentation