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. 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 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
Archived
This topic is now archived and is closed to further replies.