I have run into similar issues in far less convoluted circumstances.
I'm not going to try to decode your query but using an alias can help
clarify things.
...
team_name_to
FROM players_bids AS PB
INNER JOIN players ON players_bids.players_id = players.players_id
...
and rename all your player_bids to reference to the alias.
It usually resolves the problem for me.
- michael dykman
> On Tue, Nov 16, 2010 at 11:09 AM, Tompkins Neil
> <neil.tompkins@stripped> wrote:
>> Hi
>>
>> I've the following query :
>>
<snip/>
>>
>> but the problem I have is that when referencing players_bids.users_id_from
>> within the UNION I get back the following error :
>>
>> Error Code: 1054
>> Unknown column 'players_bids.users_id_from' in 'where clause'
>>
>> Any ideas how to overcome this problem ?
>>
>> Cheers
>> Neil
>>
>
>
>
> --
> - michael dykman
> - mdykman@stripped
>
> May the Source be with you.
>
--
- michael dykman
- mdykman@stripped
May the Source be with you.
