求一条SQL查询语句！

[bnc9595]

涉及到3个表了，小弟晕了。

其中一个表是专题表【special】，用于放置专题名称及路径
表2是专题与新闻的关系【special_news】，是对应关系，一个专题（specialID）下，包含有N多新闻（newsID）
表3是新闻列表，新闻内容，标题，栏目等等

我已经将专题读取了出来

string Sql = " Select [SpecialID],[SpecialCName],[SavePath],[saveDirPath],[FileName],[FileEXName],[isDelPoint] From [" + DBConfig.TableNamePrefix + "news_special] Where [ParentID]='" + this.Param_CurrentSpecialID + "'";
            DataTable dt = CommonData.DalPublish.ExecuteSql(Sql);
            if (dt == null || dt.Rows.Count == 0) return "";

现在我想做个循环

for (int i = 0; i < dt.Rows.Count; i++)
            {

把每个专题下的新闻都显示出来
循环里的SQL应该如何来写啊？谢谢各位了！

[cq139514]

Select * from special_news where specialID='"+dt.Rows[i].Item["SpecialID"].tostring+"'

[周公]

用连接查询就可以了。

[farwy]

declare @specialID int 
set @specialID  = 1

select * from news a 
inner join special_news b
on a.newsid = b.newsid
where specialID = @specialID

[farwy]

数据层调用这样写比较好。

public int Insert( int userID,DateTime loginTime,DateTime logoutTime ) {
            //构造SQL语句
            string sql = "INSERT INTO [Loginfo](UserID,LoginTime,LogoutTime)VALUES(@UserID,@LoginTime,@LogoutTime); SELECT @@Identity";

            //构造参数
            SqlParameter[] parameters = { 
                new SqlParameter("@FinaId",SqlDbType.DateTime),
                new SqlParameter("@UserId",SqlDbType.DateTime),
                new SqlParameter("@FinaType",SqlDbType.DateTime),
            };
            
            //为参数赋值
            int i = 0;
            parameters[ i++ ].Value = userID;
            parameters[ i++ ].Value = loginTime;
            parameters[ i++ ].Value = logoutTime;

            //执行SQL语句
            try {
                object obj = db.ExecuteScalar( CommandType.Text, sql, parameters ) ?? "-1";
                int Identity;
                if( int.TryParse( obj.ToString(), out Identity ) )
                    return Identity;
                return -1;
            } catch( Exception exp ) {
                throw exp;
            }
        }

[hypnoz]

declare @specialID int
set @specialID = 1

select * from news a
inner join special_news b
on a.newsid = b.newsid
where specialID = @specialID

[abeniaj0427]

Select  * from special_news where specialID='"+dt.Rows[i].Item["SpecialID"].toString()+"'

[bnc9595]

拜托大家写成普通的sql语句

[bnc9595]

string s_newsSql = "select top " + Param_Loop + " " + SqlFields + " from" +
                                   " " + SqlCondition + " inner join [" + DBConfig.TableNamePrefix + "Special_news] on [" + DBConfig.TableNamePrefix + "news].NewsID=[" + DBConfig.TableNamePrefix + "Special_news].SpecialID where [SpecialID]='" + dt.Rows[i]["SpecialID"].ToString() + "' + SqlOrderBy";

这样写不知道对不对？求高手帮忙看一下!

[Gihrye]

select t1.name,t3.name form table1 t1 inner join table2 t2 on t1.t1id=t2.id inner join table3 t3 on t2.t3id=t3.id where t1.id=123

一个样板，你可以照着这个样板写
table1和table3事多对多关系，table2是关联表

[善缘2022]

学习下。帮顶