Database Query Builder -- errors and aliases

[Bill Humphrey]

Boy did that crash RunRev fast! I don't even have to worry about 
changing anything back to the way it was ;)

Trevor DeVore wrote:

> 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...
>
>