mysql-test/r/join.result


1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29

id	id
107	107
75	75
id	count(t2.id)
75	1
107	1
id	count(t2.id)
75	1
107	1
id	catid	stateid	countyid
27	2	12	11
28	2	12	11
29	2	12	25
26	1	6	37
id	catid	stateid	countyid
26	1	6	37
27	2	12	11
28	2	12	11
29	2	12	25
a
1
2
a	a	b
2	2	3
d	d
2001-08-01	NULL
0000-00-00	NULL
d
0000-00-00