Important: These examples follow the query pattern you supplied: SELECT ... FROM Ledger WHERE .... Tally field names and availability can vary by report, object, TallyPrime release, and whether the query is executed through an ODBC/TDL collection interface. Test a small query first. If a field is not exposed in your environment, inspect the available methods/fields and replace it with the exact field name.

Tip: In a SQL-like Tally query, SELECT * is useful for exploration, but explicit field lists are usually better for production because they keep the returned data focused.