string sql = String.Format("select distinct A.线路 from" +
" (select 线路,站点所属 from LineSite where 站点名称 = '{0}') A," +
" (select 线路,站点所属 from LineSite where 站点名称 = '{1}') B " +
" where A.线路 = B.线路 and A.站点所属 = B.站点所属 and "+
" ("
+" select Count(*) as stationCount "
+ " from lineSite, "
+ " (select siteID from lineSite where 线路='A.线路' and 站点名称='{0}' and 站点所属='上行线') A, "
+ " (select siteID from lineSite where 线路='A.线路' and 站点名称='{1}' and 站点所属='上行线')B, "
+ " (select siteID from lineSite where 线路='A.线路' and 站点名称='{0}' and 站点所属='下行线') C, "
+ " (select siteID from lineSite where 线路='A.线路' and 站点名称='{1}' and 站点所属='下行线')D "
+ " where lineSite.线路='A.线路' "
+ " and "
+ " ("
+ " ( A.siteId < B.SiteID "
+ " AND linesite.siteID between A.siteId and B.SiteID"
+ " )"
+ " OR"
+ " ( A.siteId >= B.SiteID "
+ " AND "
+ " linesite.siteID between c.siteId and d.SiteID "
+ " )"
+ " )"
+ ") > 0 ",
"师大", "北国商城");
Access数据库 SQL语句如上所示,这样写有问题啊,求高人~
已经解决了string sql = String.Format("select distinct lineSite.线路 "
+ " from lineSite, "
+ " (select siteID,线路 from lineSite where 站点名称='{0}' and 站点所属='上行线') A, "
+ " (select siteID,线路 from lineSite where 站点名称='{1}' and 站点所属='上行线')B, "
" (select siteID,线路 from lineSite where 站点名称='{0}' and 站点所属='下行线') C, "
" (select siteID,线路 from lineSite where 站点名称='{1}' and 站点所属='下行线')D "
" where a.线路 in ("
" select distinct E.线路 from"
+" (select 线路,站点所属 from LineSite where 站点名称 = '师大') E,"
+" (select 线路,站点所属 from LineSite where 站点名称 = '北国商城') F"
+" where E.线路 = F.线路 and E.站点所属 = F.站点所属"
+" ) AND "
+" a.线路=b.线路 and c.线路=b.线路 and c.线路 = d.线路 "
还是谢谢