Posted by IchBin on 11/11/05 02:10

Dave Smith wrote:
> I am joining three tables all of which contain the same field name.
> example:
> CLNT_STATS_YTD.Vol_Collected
> CLNT_STATS_MTD.Vol_Collected
> CLNT_STATS_TD.Vol_Collected
>
> If I try to reference them using those names I get no data. If I use the
> last half "Vol_Collected" I get the last value of the three. I'm not
> sure how to reference them seperately in php. Thank you for any help.
>
> Dave
What does your SQL statement look like..

--


Thanks in Advance...
IchBin, Pocono Lake, Pa, USA
http://weconsultants.servebeer.com/JHackerAppManager
__________________________________________________________________________

'If there is one, Knowledge is the "Fountain of Youth"'
-William E. Taylor, Regular Guy (1952-)

• Next in forum: Re: identical named field names in multiple tables
• Prev in forum: Re: identical named field names in multiple tables
• Thread view: Re: identical named field names in multiple tables

[Reply to this message]