[SOLVED] Join Error: dubble keys

[ramli]

I have a problem with my database structuere, and i am not sure how to resolve it.

I have two tables.

 

Users

Username

Password

Role

|

|

|

|

|

Client_data

Client_ID

Username

Location

Zipcode

 

Execute the following qurey

 

SELECT * FROM Users INNER JOIN Client_data ON Users.Username=Client_data.Username

 

Workes fine but when i like to search on username i get a error

 

SELECT * FROM Users INNER JOIN Client_data ON Users.Username=Client_data.Username WHERE Username LIKE '%$search%'

 

Error: #1052 - Column 'username' in field list is ambiguous

 

I know it is a problem coused by the colomn username only i don't know wat to do to resolve it, can anyone help me pleace ?

 

Thx in advance

[rhodesa]

you have to specify the table:

SELECT * FROM Users INNER JOIN Client_data ON Users.Username=Client_data.Username WHERE Users.Username LIKE '%$search%'

[ramli]

yep it solved my problem.... thanks