select a.大组名,b.小组名 from (select * from dz where name<>'') a cross join (select * from xz where name<>'') b
报什么错? select a.大组名,b.小组名 from (select * from dz where name<>'') a join (select * from xz where name<>'') b on a.xxx=b.xxx
select a.大组名,b.小组名 from (select * from dz where name<>'') a join (select * from xz where name<>'') b on ...或select a.大组名,b.小组名 from (select * from dz where name<>'') a , (select * from xz where name<>'') b
select a.大组名,b.小组名 from (select * from dz where name<>'') a join (select * from xz where name<>'') b on a.xxx=b.xxx
join (select * from xz where name<>'') b on ...或select a.大组名,b.小组名 from (select * from dz where name<>'') a ,
(select * from xz where name<>'') b