On Jun 6, 2005, at 6:28 AM, Bill Humphrey wrote:
In case anyone else wants to use this great thing extensively then when designing your databases always use unique names for every column even when in different tables because if you refer to a column as tablename1.shipID and another one as tablename2.shipID even though SQL is happy with this the database query builder update feature will choke.
You could probably get around this by doing: SELECT tablename1.shipID AS ShipID1, tablename2.shipID AS ShipID2... -- Trevor DeVore Blue Mango Multimedia [EMAIL PROTECTED] _______________________________________________ use-revolution mailing list use-revolution@lists.runrev.com http://lists.runrev.com/mailman/listinfo/use-revolution
