inner join maybe

[Keith444]

hi i have the query below which is getting info from 2 tables, think there is a conflict as i need to show in my output

#CODE##PlayerPhone#

this should format like 6144444444

but i am getting 616144444444

do i need a inner join or something?

if so how would i do this

many thanks

Keith

[Dan_Bracuk]

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.

[Keith444]

how do i do a cfdump of this query? and what u mean by ambiguous?

[Dan_Bracuk]

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.

[Keith444]

ok sorted it thank you