sandy1028 Posted April 18, 2011 Share Posted April 18, 2011 select id,mid,value from cvalue where id=27626130 result is : id,mid,value 27626130 143 NRIs 27626130 29 News By Industry 27626130 53 424 27626130 40 May 18, 2010, 08.45pm In the table cvalue, How can i select all the id's in which "mid" doesn't have the row for 11. Quote Link to comment https://forums.phpfreaks.com/topic/234039-select-id-for-the-row-if-it-doesnt-exists/ Share on other sites More sharing options...
kickstart Posted April 18, 2011 Share Posted April 18, 2011 Hi What do you mean "row for 11"? Is mid the key to another table and is 11 a value on that table? All the best Keith Quote Link to comment https://forums.phpfreaks.com/topic/234039-select-id-for-the-row-if-it-doesnt-exists/#findComment-1202899 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.