On Sat, May 15, 2010 at 10:00 PM, Rich Shepard <[email protected]> wrote: > I ran Ledger Doctor on my tables and discovered 4 transactions from 2004 > that need to be deleted. The reported information for the orphaned rows are > the trans ID and the date. How do I identify the table in which these rows > are found? > > I looked at acc_trans and gl, but the select statements returned nothing.
HI Rich, these transactions are from acc_trans table and can be looked up as: SELECT * FROM acc_trans WHERE trans_id IN (id1, id2, id3 ... etc.) and can be deleted as: DELETE FROM acc_trans WHERE trans_id IN (id1, id2, id3 ... etc.) Regards Armaghan _______________________________________________ SQL-Ledger mailing list [email protected] http://lists.ledger123.com/mailman/listinfo/sql-ledger
