SQL数据库常用查询语句

zjaiyd

select*from t_account
order by fnumber
--454 455
Select*from t_unitgroup
Select*from t_measureunit
--同一个计量单位组里Fstandard=1对应的fmeasureunitid
Select*from t_account

select*from t_currency
--核算项目使用详情横纵表--核算项目使用ID--FDETAIL
select*from t_itemdetail--核算项目使用详情横表
select*from t_itemdetail--核算项目使用详情纵表
select*from t_itemclass--核算项目类别表

select*from t_itemclass--核算项目类别表
select*from t_itemdetail--核算项目使用详情横表
select*from t_emp

select*from t_item--基础资料表
where fitemid=181
select a.fname,b.fnumber,b.fname
from t_itemclass a
join t_item b on a.fitemclassid=b.fitemclassid
join t_itemdetailv c on c.fitemid=b.fitemid
join t_itemdetail d on d.fdetailid=c.fitemid
where d.fdetailid=206

--O记录失
--FDETAILCOUNT记数不对
--存在重复使用组合，但对应的FDETAILID又不相同


select*from t_itemclass

select b.fnumber,b.fname,a.fname
from t_itemclass a
join t_item b on a.fitemclassid=d.fitemclassid
where a.fname='供应商'
order by a.fnumber