shan_cool Posted August 9, 2006 Share Posted August 9, 2006 Hi all, I have two tables "table1" and "table2" and "id" is the field common to both the tables.. All id data will be in "table1" say 10,20,30,40,50,60 . but only few of them will get stored in "Table2" say 20 ,40.Now i need the retrieve the values of id's that are in "table1" and not in "table2" Ex: 10,30,50,60.My query is"Select h1.id from table1 h1,table2 h2 where h1.id Not In(h2.id)""Select h1.id from table1 h1,table2 h2 where h1.id <>2.id)"both display Repetition of all values and gives me 'n' number of records.. cartesian productplz lemmme know how to do it?Thx in advance,Shan Link to comment https://forums.phpfreaks.com/topic/16989-query-problem/ Share on other sites More sharing options...
shan_cool Posted August 9, 2006 Author Share Posted August 9, 2006 hi, I have tried that too. it displays the same numbaer of repeated records ony... any other way? Link to comment https://forums.phpfreaks.com/topic/16989-query-problem/#findComment-71619 Share on other sites More sharing options...
fenway Posted August 9, 2006 Share Posted August 9, 2006 Try the following:[code]Select h1.id from table1 h1 left join table2 h2 on ( h1.id = h2.id) where h2.id is null[/code] Link to comment https://forums.phpfreaks.com/topic/16989-query-problem/#findComment-71816 Share on other sites More sharing options...
shan_cool Posted August 10, 2006 Author Share Posted August 10, 2006 Hi, Thanks Verymuch for ur reply.. The Query works fine..Rgds,Shan Link to comment https://forums.phpfreaks.com/topic/16989-query-problem/#findComment-72273 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.