从两个表中检索数据(Retrieve data from two table)

从两个表中检索数据(Retrieve data from two table)

我有两个表tblRegistration(id,name,program,regdno,address)和tblDue(id,regdno,amountdue) 。 我想要的是从textbox传递regdno，然后从tblDue检索name ， program值的形式tblRegistration和tblDue 。

我试过的是，

select t1.name,t1.program, t2.amountdue from tblRegistration as t1 inner join tblDue as t2 on t2.regdno= t1.regdno;

它返回两个表中具有相同regdno所有值。

帮助我获得那些只有我从文本框提供的regdno值。

对不起，语言。 先谢谢你。

I have two tables tblRegistration(id,name,program,regdno,address) and tblDue(id,regdno,amountdue). What I want is to pass regdno from a textbox and then retrieve the name, program values form tblRegistration and amountdue from tblDue.

What i tried is ,

select t1.name,t1.program, t2.amountdue from tblRegistration as t1 inner join tblDue as t2 on t2.regdno= t1.regdno;

It returns all values having same regdno in both tables.

Help me on getting those values only whose regdno I provide from textbox.

Sorry for the language. Thank you in advance.

最满意答案

修改你的查询sql像这样：

select t1.name,t1.program, t2.amountdue from tblRegistration as t1 inner join tblDue as t2 on t2.regdno= t1.regdno where t1.regdno=yourvaluetestbox;

Modifiy your query sql like this:

select t1.name,t1.program, t2.amountdue from tblRegistration as t1 inner join tblDue as t2 on t2.regdno= t1.regdno where t1.regdno=yourvaluetestbox;