On Tue, 18 Oct 2011, Chris Travers wrote:
acc_trans.trans_id is a foreign key. It references, in practice: select id from ar union select id from ap union select id from gl;
Chris, I'm confused. Are you writing that the acc_trans.trans_id (the primary key on that table, I assume) consists strictly of foreign keys from ar, ap, and gl? Wow! Does an update or deletion cascade from acc_trans to ar, ap, and gl? Rich _______________________________________________ SQL-Ledger mailing list [email protected] http://lists.ledger123.com/mailman/listinfo/sql-ledger
