问题描述
朋友,我需要一些帮助
在我的项目(asp.net)中,sqlserver 2005是后端,我需要查询从多个表中检索数据
对于例如
table1:traindetail(tid(p.key),名称,来源,目的地,日期)
table2:class(tid(f.key),class,seat)
我有一个表格收集用户输入的信息,例如来源,目的地,类别,日期
当用户提交时,它将检查两个表并匹配,然后显示确认消息
如何获取它
hi friends i need some helps
In my project(asp.net) sqlserver 2005 is backend in this i need query for retrive data from multiple table
for eg
table1:traindetail(tid(p.key),name,source,destination,date)
table2:class(tid(f.key),class,seat)
i have one form in i collect users input like source,destination,class,date
when user submit then it check the two tables and it match then display conformation message
how can i get it
推荐答案
Select source, destination, class, [date]
from table1
join table2 on table1.tid = table2.tid
SQL Joins[^]
select A.tid, A.name, B.class, B.seat from traindetail as A inner join class as B on A.tid=B.tid where A.source = 'SourceFromUser' and A.destination = 'DestinationFromUser' and A.date=convert(datetime,'DateFromUser',103) and B.class='classFromUser'
执行此查询并检查行数.如果行数是> 0,然后显示构型,否则显示适当的错误消息.
希望这会有所帮助.
execute this query and check the row count. if the rowcount is > 0 then display conformation otherwise display appropriate error message.
hope this helps..
这篇关于从多个表中选择数据的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持!