I just read it 3 times and I don't understand it. On Wed, Jan 28, 2009 at 3:22 PM, Christoph Boget <christoph.boget@xxxxxxxxx>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 > >