select c.co_id, c.companyname, c.companytype, c.province, c.city,
j.cartype_id, j.etprice, n.info_id, n.cuxiao_topic
from tbl_jxs_car j
join tbl_company_list c on c.co_id=j.jxs_id
join tbl_car_info i on i.cartype_id=j.cartype_id
left join newtable n on c.co_id=n.jxs_id
where i.isdelete=0 and c.is_delete=0 and j.etprice<>'0' and j.etprice<>''
order by j.dateandtime desc
j.cartype_id, j.etprice, n.info_id, n.cuxiao_topic
from tbl_jxs_car j
join tbl_company_list c on c.co_id=j.jxs_id
join tbl_car_info i on i.cartype_id=j.cartype_id
left join newtable n on c.co_id=n.jxs_id
where i.isdelete=0 and c.is_delete=0 and j.etprice<>'0' and j.etprice<>''
order by j.dateandtime desc
解决方案 »
- SQL数据库语句解释 能帮小弟逐字逐句解释下下面的代码吗?先谢谢拉
- sql2005 数据类型转换 语句
- 求一条update语句
- 一个取记录的问题
- 一个简单的画ER图问题..在线等ing
- sql查询连续时间问题
- 两个触发器的比较??
- EXEC sp_MSforeachtable 'exec sp_changeobjectowner ''?'',''king'' '
- win7 旗舰版装sql啊 求指点
- select * from biao where id in ('1,2,3,4,5,6,7,8,98,9,11,22,33,66,55,44,99,88,77')这个用in 执行起来太慢,怎么解决
- T-SQl语句的流程控制有地方不懂
- 关于登录用户与数据库用户的一点问题。
from newtable
where info_id in (select max(info_id)
from newtable
group by jxs_id)
left join (select jxs_id,info_id, cuxiao_topic
from newtable
where info_id in (select max(info_id)
from newtable
group by jxs_id)) n on c.co_id=n.jxs_id
...