problem in query
Posted: Mon Sep 04, 2006 6:16 am
hello
i have a little problem,
there are 2 tables hain
first table contains main 5000 records
and second contains 2500 records.
i want to fetch those records of table two which are not present in table 1.
table1 structure:
autoid:
userid:
it contains values from 1-10
table2 structure
autoid:
userid_pass:
it contain values 1,3,5,7
means our query gives the result as : 2,4,6,8,10
kindly make a valid query for this.
eshban
--
<a href="http://groups.google.com/group/eshbansworldofinfo" target="_blank" onclick="return top.js.OpenExtLink(window,event,this)">Join My Group</a>
--
<a href="http://www.GlitterMaker.com/">
<img src="http://graphics.GlitterMaker.com/8/219/ ... 418102.gif" border="0"></a><br>
Plz Rate My Picture At:
=================
http://www.ratedesi.com/view.php?id=172861&aim=%n
i have a little problem,
there are 2 tables hain
first table contains main 5000 records
and second contains 2500 records.
i want to fetch those records of table two which are not present in table 1.
table1 structure:
autoid:
userid:
it contains values from 1-10
table2 structure
autoid:
userid_pass:
it contain values 1,3,5,7
means our query gives the result as : 2,4,6,8,10
kindly make a valid query for this.
eshban
--
<a href="http://groups.google.com/group/eshbansworldofinfo" target="_blank" onclick="return top.js.OpenExtLink(window,event,this)">Join My Group</a>
--
<a href="http://www.GlitterMaker.com/">
<img src="http://graphics.GlitterMaker.com/8/219/ ... 418102.gif" border="0"></a><br>
Plz Rate My Picture At:
=================
http://www.ratedesi.com/view.php?id=172861&aim=%n