I know how to do this in MSSQL and it is killing me for not being able to find the solution yet.<br /><br />I created a new table called "inchat". Two fields: C_Username, C_Last.<br /><br />I also added a new field in the w3t_online table called "O_InChat" (VARCHAR(3) DEFAULT 'no').<br /><br />I want to run a query that match the C_Username (from the inchat table) with the O_Username (from the w3t_online table) and update the O_InChat field (in the w3t_Online table) to 'yes' for the matched fields.<br /><br />I came up with this - which doesn't work:<br /><pre><font class="small">code:</font><hr><br />UPDATE inchat <br />INNER JOIN w3t_online <br />ON inchat.C_Username = w3t_online.O_Username <br />SET w3t_online.O_InChat = "yes"<br /></pre><hr><br />:wallbash: :wallbash:<br /><br />I don't know what I'm doing wrong....<br /><br />Thanks in advance<br /><br />Warm regards<br /><br />Nikos

Hmmm ... I couldn't find any way to do that either, using only a MySQL query.<br /><br />Of course, using PHP, you can first do a select query to get the usernames that match across the inchat and w3t_Online tables, and then do the update query on the w3t_Online table using the result from the first query. I could post some code if you want.<br /><br />Maybe someone else knows a way to do this with a single query.