Re: Making a Variable from different tables with Matching Db fields?
| From: | Andrew Ballard | Date: | Wed, 28 Jan 2009 21:31:24 +0000 |
| Subject: | Re: Making a Variable from different tables with Matching Db fields? | ||
| References: | 1 2 3 4 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-287315@lists.php.net to get a copy of this message | ||
On Wed, Jan 28, 2009 at 4:22 PM, Christoph Boget
<christoph.boget@gmail.com> wrote:
>> Well I'm stuck I have the AdminID but now I can't seem to use it to pull
>> workorders with that AdminID . I couldn't get your block to work Andrew :(
>> I think I'm just not using it right now that I have it...lol
>
> Because there is ambiguity w/r/t the columns you are selecting, you'll
> need to use aliases.
>
> http://dev.mysql.com/doc/refman/5.1/en/identifiers.html
>
> In your code, when you are referencing the column, do so using the
> alias. That should solve your problem.
>
> thnx,
> Christoph
>
>
You're right about the ambiguity. I didn't even pay attention to his
SELECT list. Actually, though, in this case aliases aren't even
necessary. Since workorders.AdminID and admin.AdminID are going to be
the same value since that's a join condition, so the OP really only
needs to choose one and use it.
Andrew