Hi there, In my database having 2,00,000 records. Am using simple query in query.. That is .... --> select col_name1 from t1 where col_name2 not in(select col_name2 from t1 where...)
But this query ...is make hang my server... if i check about this process... that shows "Copying to tmp table" But i can't get the output. Anyone can help me........ --------------------------------- Looking for earth-friendly autos? Browse Top Cars by "Green Rating" at Yahoo! Autos' Green Center. [Non-text portions of this message have been removed]
