summaryrefslogtreecommitdiff
path: root/mysql-test/r/join.result
blob: 39331fc68e440c7093f2d6e9c5ebc45f5b5ff958 (plain)
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
30
31
32
33
34
35
36
37
38
39
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
d
2001-08-01
0000-00-00
COUNT(t1.Title)
1
COUNT(t1.Title)
1
t1_id	t2_id	type	cost_unit	min_value	max_value	t3_id	item_id	id	name
22	1	Percent	Cost	100	-1	6	291	1	s1
23	1	Percent	Cost	100	-1	21	291	1	s1