一堆问题之三 select a1.F1, a1.F2 a2.F4 from a1,a2 where a1.F1=a2.F3 解决方案 » 免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货 select a1.f1,a1.f2,a2.f4from a1,a2where a1.f1=a2.f3 select a1.F1, a1.F2 ,isnull(a2.F4,'0') as score from a1,a2 where a1.F1=a2.F3 Select A.F1,A.F2,B.F4 from TableA,TablB where A.F1=B.F3 select a.f1.a.f2,(case when b.f4 is null then 0 else b.f4 end) as b.f4from a1 a,a2 b where a.f1=b.f3 select *,(select top 1 F4 from a2 where F3 = a1.F1) 联合 from a1 SELECT a1.f1,a1.f2,a2.f4 from a1 LEFT JOIN a2 ON a1.f1=a2.f3一切OK? SELECT a1.F1, a1.F2, a2.F4FROM a1 INNER JOIN a2 ON a1.F1 = a2.F3; 请教个sql,无条件连接,怎么实现阿? 有如下两个表 求 查询语句 请教各位 JMAIL后 数据资料如何处理? 请vivianfdlpw()来接分! sqlsever中的表和数据怎样转到mysql中? 邹大侠 进销存出库单,入库单 ,代码表结构设计问题? 左右为难! 求一SQL sERVER连接字符串的每一段的详细含义 数据库数据丢失,紧急求助........ 强制还原的SQL语句怎么写? xshell 可以直接连接mysql吗 如何在smalldatetime字段中只存储时间啊? 怎样把microsoft word 文档存入SQL Server 数据库中
from a1,a2
where a1.f1=a2.f3
from a1 a,a2 b where a.f1=b.f3
LEFT JOIN a2 ON a1.f1=a2.f3一切OK?
FROM a1 INNER JOIN a2 ON a1.F1 = a2.F3;