mysql> select * from tt_a;
+------+
| a |
+------+
| 1 |
+------+
1 row in set (0.00 sec)mysql> select * from tt_b;
+------+------+------+------+
| a | b | c | d |
+------+------+------+------+
| 1 | a | v | c |
| 1 | ad | ev | ec |
| 1 | sda | eev | cvc |
| 1 | rta | sdv | sdc |
+------+------+------+------+
4 rows in set (0.00 sec) tt_a 与 tt_b 2表的字段A 关联
请问如何写出 以下体现形式
(tt_a)( tt_b )
+------+------+------+------+------+
| a | a | b | c | d |
+------+------+------+------+------+
| 1 | 1 | a | v | c |
| | 1 | ad | ev | ec |
| | 1 | sda | eev | cvc |
| | 1 | rta | sdv | sdc |
+------+------+------+------+------+
+------+
| a |
+------+
| 1 |
+------+
1 row in set (0.00 sec)mysql> select * from tt_b;
+------+------+------+------+
| a | b | c | d |
+------+------+------+------+
| 1 | a | v | c |
| 1 | ad | ev | ec |
| 1 | sda | eev | cvc |
| 1 | rta | sdv | sdc |
+------+------+------+------+
4 rows in set (0.00 sec) tt_a 与 tt_b 2表的字段A 关联
请问如何写出 以下体现形式
(tt_a)( tt_b )
+------+------+------+------+------+
| a | a | b | c | d |
+------+------+------+------+------+
| 1 | 1 | a | v | c |
| | 1 | ad | ev | ec |
| | 1 | sda | eev | cvc |
| | 1 | rta | sdv | sdc |
+------+------+------+------+------+
解决方案 »
- WHERE条件中匹配的问题
- Excel VBA 连接 MySQL
- ERROR 1146 (42S02): Table 'mysql.procs_priv' doesn't exist
- 这个SQL极难,绝对需要高手!!!
- 数据库取值问题 急!~~~~~~~~~~~~
- 一个奇怪的问题!
- 请问如何让一个键值自动加一,自动得到当前时间?
- 如何实时监控mysql中的SQL语句的执行情况?
- python程序向mysql插入数据,但数据库显示为空
- mysql Cluster 内存存储数据机集群由于突发原因集体掉电,恢复后数据是不是都没了。
- MySql内存增长过快导致崩溃的问题
- Mysql里有1000多个sleep连接,还在增加,怎么查原因
用报表来实现你的格式,比如重复的不打印
。。没看懂结果也没出现要的形式啊
FROM tt_b a
LEFT JOIN tt_a b ON a.a=b.a
ACMAIN_CHM
lzd_83
得出来的都是以下结果。
select * from tt_a ,tt_b where tt_a.a=tt_b.aSELECT *,b.a
FROM tt_b a
LEFT JOIN tt_a b ON a.a=b.a+------+------+------+------+------+
| a | a | b | c | d |
+------+------+------+------+------+
| 1 | 1 | a | v | c |
| 1 | 1 | ad | ev | ec |
| 1 | 1 | sda | eev | cvc |
| 1 | 1 | rta | sdv | sdc |
+------+------+------+------+------+
FROM tt_b a
LEFT JOIN tt_a b ON a.a=b.a limit 1
union all
SELECT '',a.*
FROM tt_b a
LEFT JOIN tt_a b ON a.a=b.a limit 1,10已经说过,用报表来实现你的格式,比如重复的不打印