Join two tables

[vks.gautam1]

Select jal.* from jal inner join ussd_master on jal.mob_no=ussd_master.mob_no where ussd_master.act_date> #10/1/2008 #;


Here i got result where mobile numbers which are activated after 10/1/2008 (mm,dd,yyyy) .

How can i write a query where i get number which are in this given result.

One query work for the both results

 

[MattP]

If your data is in a datatable you can access the Table.Rows.Count to get the number of records returned.

If you're using a datareader you're going to need to use 2 queries and use the DataReader's ReadNext method.

SELECT jal.* FROM jal ... #10/1/2008 #; SELECT @@ROWCOUNT

 

[cjard]

How can i write a query where i get number

What do you mean by "number"

 

[vks.gautam1]

query

This is data of Mobile numbers.

First Table
Packet No. MobNo. ActvDate
DC-A0167 9915464942 09/30/2008
DC-A0167 9915466215 10/4/2008
DC-A0167 9779971722 11/6/2008
DC-A0167 9915982867 11/7/2008
DC-A0164 9815982980 12/5/2008
DC-A0167 9915462353 12/5/2008
DC-A0167 9915461587 12/5/2008



second table

MobNo. ActvDate
9915464942 11/30/2008
9915464942 05/30/2007
9915466215 12/4/2008
9779971722 12/6/2008
9915982867 12/7/2008
9815982980 12/5/2008
9915462353 12/5/2008
9915461587 12/5/2008

Some of the nos are doubled in table in database like in color

Here Common Field is MobNo
i want to retrieve data which is older than Oct month. Here if i make a query it gives me same MobNo twise(color nos).

select * from table1,table2 where ActDate<#10/1/2008#

 

[cjard]

select * from table1 t1 INNER JOIN table2 t2 ON t1.MobNo = t2.MobNo where ActDate<#10/1/2008#

 

[vks.gautam1]

Duplicate values

it is giving duplicate values.

if i use distinct . that is not working .

Packet No. MobNo. ActvDate
DC-A0167 9915464942 09/30/2008
OC-A0167 9915464942 06/30/2008

 

[MattP]

it is giving duplicate values.

if i use distinct . that is not working .

Packet No. MobNo. ActvDate
DC-A0167 9915464942 09/30/2008
OC-A0167 9915464942 06/30/2008

Those don't look like duplicate rows to me.

 

[cjard]

if i use distinct . that is not working .

There is no bigger indicator that a SQL programmer doesnt know what he is doing, than by use of DISTINCT to suppress duplicate rows arising from a cartesian join..