This content has been marked as final. Show 4 replies
In the select clause of your query, either don't qualify the unambiguous field names at all, or give them alias names. Then cfdump your query so you get a better idea of what is happening.
how do i do a cfdump of this query? and what u mean by ambiguous?
Read the cfml reference manual for cfdump. If you don't have one, google <cfdump>, you'll find it.
By unambiguous, I meant that the field exists in only one of the tables from which you are selecting in your query.
ok sorted it thank you