jenniferG Posted March 28, 2008 Share Posted March 28, 2008 we have two tables, pimclients and pimcontacts with a common column clientname. clientname is unique in pimclients. we want to set the value of clientindex in pimcontacts equal to the value of indexa in pimclients where the columns clientname matches. Thanks, Jennifer G Quote Link to comment https://forums.phpfreaks.com/topic/98376-mysql-syntax/ Share on other sites More sharing options...
mb81 Posted March 28, 2008 Share Posted March 28, 2008 So what's your question? Quote Link to comment https://forums.phpfreaks.com/topic/98376-mysql-syntax/#findComment-503433 Share on other sites More sharing options...
jenniferG Posted March 28, 2008 Author Share Posted March 28, 2008 I'm sorry, we are lookoing for help with the syntax to do this/ Quote Link to comment https://forums.phpfreaks.com/topic/98376-mysql-syntax/#findComment-503449 Share on other sites More sharing options...
fenway Posted March 28, 2008 Share Posted March 28, 2008 Some table structure would help. Quote Link to comment https://forums.phpfreaks.com/topic/98376-mysql-syntax/#findComment-503628 Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.