create table main_info
(
sk_id int not null,
收款单号 varchar(20) not null,
收款日期 datetime not null,
收款金额 money not null,
简称 varchar(100) not null,
收款类别 varchar(20) not null,
收款员 varchar(20) not null
PRIMARY key(sk_id)
);
create table desc_info
(
item_id int not null,
sk_id int not null,
本次收款 money not null,
减免金额 money not null,
业务单号 varchar(20) not null,
车牌号码 varchar(20) not null
PRIMARY key(item_id)
);
insert into main_info values (1,'HZ-20130608001','2013-06-08',320,'测试','现金','管理员')
insert into desc_info values (1,1,100,0,'HZ-20139698004','粤Y-0001')
insert into desc_info values (2,1,120,0,'HZ-20139698004','粤Y-0001')
insert into desc_info values (3,1,100,0,'HZ-20139698005','粤Y-0002')
sql语句
select 收款日期,收款单号,简称,收款类别,收款员,收款金额,减免金额,本次收款,车牌号码,业务单号 from main_info m left join desc_info d on m.sk_id=d.sk_id order by 简称,收款类别,收款日期