我有两个表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;更多推荐
发布评论