sql
select n.id,n.title,n.createtime,c.[name] from news n where [content]= '111111' inner join category c on n.caid=c.id order by n.createtime desc帮我看看那里错了 提示说inner附近有语法错误 --------------------编程问答-------------------- select n.id,n.title,n.createtime,c.[name] from news n inner join category c on n.caid=c.idwhere [content]= '111111'
order by n.createtime desc --------------------编程问答-------------------- 晕.有了where 还加inner join 肯定不能执行了.好好看一下基础吧 --------------------编程问答-------------------- select n.id,n.title,n.createtime,c.[name] from news n inner join category c on n.caid=c.id where [content]= '111111' order by n.createtime desc --------------------编程问答-------------------- 不好意思.是我错.我想说你的顺序弄错了. --------------------编程问答-------------------- select n.id,n.title,n.createtime,c.[name] from news n inner join category c on n.caid=c.id where [content]= '111111' order by n.createtime desc --------------------编程问答-------------------- select n.id,n.title,n.createtime,c.[name] from news n inner join category c on n.caid=c.id
and [content]= '111111'
order by n.createtime desc --------------------编程问答-------------------- select n.id,n.title,n.createtime,c.[name] from news n inner join category c on n.caid=c.id where [content]= '111111' order by n.createtime desc --------------------编程问答-------------------- 正解,先连接好两张表 然后再加where条件 --------------------编程问答--------------------
--------------------编程问答-------------------- select n.id,n.title,n.createtime,c.[name] from news n inner join category c on n.caid=c.id where [content]= '111111' order by n.createtime desc --------------------编程问答--------------------
select n.id,
n.title,
n.createtime,
c.[name]
from news n
inner join category c
on n.caid=c.id
where [content]= '111111'
order by n.createtime desc
--------------------编程问答-------------------- 谢谢 解决了
select n.id,n.title,n.createtime,c.[name] from news n inner join category c on n.caid=c.id where [content]= '111111' order by n.createtime desc
补充:.NET技术 , ASP.NET