|
|
Posted by Erwin Moller on 09/28/73 12:01
Mango wrote:
> Captain Paralytic wrote:
>>
>> Suppose he is querying:
>> SELECT
>> *
>> FROM db1.table
>> JOIN db2.table USING(id)
>
> That is exactly the kind of situation I am anticipating. If anyone has
> any suggestions, that would be great.
>
> -Mango
Hi Mango,
Well, in that case, you can simply mark your columns.
And don't use * to select columns.
Like this:
SELECT
db1.userid as db1_userid,
db1.name as db1_name,
db2.userid as db2_userid,
db2.city as db2_city
FROM db1.tbluser
JOIN db2.tblcity etc etc.
Regards,
Erwin Moller
Navigation:
[Reply to this message]
|