Posted by Mango on 01/29/08 16:41

Thanks a lot!

Mango :)


Erwin Moller wrote:
> 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

• Next in forum: Re: Best framework for someone who isn't scared of SQL
• Prev in forum: Re: How to use SQL "LIMIT" keyword against an MDB file
• Thread view: Re: mysql_field_database()?

[Reply to this message]