Run Code  | API  | Code Wall  | Misc  | Feedback  | Login  | Theme  | Privacy  | Patreon 

Microsoft SQL Server in 10 mn - Lesson 14 Joining Tables samples...

Language: Layout:
View schema
Execution time: 0,08 sec, rows selected: 108, rows affected: 55, absolute service time: 0,44 sec  
edit mode |  history  | discussion
   vend_name prod_name prod_price QNM
1 ACME Bird seed 10,0000 LS14A
2 ACME Carrots 2,5000 LS14A
3 ACME Detonator 13,0000 LS14A
4 ACME Safe 50,0000 LS14A
5 ACME Sling 4,4900 LS14A
6 ACME TNT (1 stick) 2,5000 LS14A
7 ACME TNT (5 sticks) 10,0000 LS14A
8 Anvils R Us .5 ton anvil 5,9900 LS14A
9 Anvils R Us 1 ton anvil 9,9900 LS14A
10 Anvils R Us 2 ton anvil 14,9900 LS14A
11 Jet Set JetPack 1000 35,0000 LS14A
12 Jet Set JetPack 2000 55,0000 LS14A
13 LT Supplies Fuses 3,4200 LS14A
14 LT Supplies Oil can 8,9900 LS14A
   vend_name prod_name prod_price qnm
1 ACME .5 ton anvil 5,9900 LS14B - a cartesian product
2 ACME 1 ton anvil 9,9900 LS14B - a cartesian product
3 ACME 2 ton anvil 14,9900 LS14B - a cartesian product
4 ACME Bird seed 10,0000 LS14B - a cartesian product
5 ACME Carrots 2,5000 LS14B - a cartesian product
6 ACME Detonator 13,0000 LS14B - a cartesian product
7 ACME Fuses 3,4200 LS14B - a cartesian product
8 ACME JetPack 1000 35,0000 LS14B - a cartesian product
9 ACME JetPack 2000 55,0000 LS14B - a cartesian product
10 ACME Oil can 8,9900 LS14B - a cartesian product
11 ACME Safe 50,0000 LS14B - a cartesian product
12 ACME Sling 4,4900 LS14B - a cartesian product
13 ACME TNT (1 stick) 2,5000 LS14B - a cartesian product
14 ACME TNT (5 sticks) 10,0000 LS14B - a cartesian product
15 Anvils R Us .5 ton anvil 5,9900 LS14B - a cartesian product
16 Anvils R Us 1 ton anvil 9,9900 LS14B - a cartesian product
17 Anvils R Us 2 ton anvil 14,9900 LS14B - a cartesian product
18 Anvils R Us Bird seed 10,0000 LS14B - a cartesian product
19 Anvils R Us Carrots 2,5000 LS14B - a cartesian product
20 Anvils R Us Detonator 13,0000 LS14B - a cartesian product
21 Anvils R Us Fuses 3,4200 LS14B - a cartesian product
22 Anvils R Us JetPack 1000 35,0000 LS14B - a cartesian product
23 Anvils R Us JetPack 2000 55,0000 LS14B - a cartesian product
24 Anvils R Us Oil can 8,9900 LS14B - a cartesian product
25 Anvils R Us Safe 50,0000 LS14B - a cartesian product
26 Anvils R Us Sling 4,4900 LS14B - a cartesian product
27 Anvils R Us TNT (1 stick) 2,5000 LS14B - a cartesian product
28 Anvils R Us TNT (5 sticks) 10,0000 LS14B - a cartesian product
29 Furball Inc. .5 ton anvil 5,9900 LS14B - a cartesian product
30 Furball Inc. 1 ton anvil 9,9900 LS14B - a cartesian product
31 Furball Inc. 2 ton anvil 14,9900 LS14B - a cartesian product
32 Furball Inc. Bird seed 10,0000 LS14B - a cartesian product
33 Furball Inc. Carrots 2,5000 LS14B - a cartesian product
34 Furball Inc. Detonator 13,0000 LS14B - a cartesian product
35 Furball Inc. Fuses 3,4200 LS14B - a cartesian product
36 Furball Inc. JetPack 1000 35,0000 LS14B - a cartesian product
37 Furball Inc. JetPack 2000 55,0000 LS14B - a cartesian product
38 Furball Inc. Oil can 8,9900 LS14B - a cartesian product
39 Furball Inc. Safe 50,0000 LS14B - a cartesian product
40 Furball Inc. Sling 4,4900 LS14B - a cartesian product
41 Furball Inc. TNT (1 stick) 2,5000 LS14B - a cartesian product
42 Furball Inc. TNT (5 sticks) 10,0000 LS14B - a cartesian product
43 Jet Set .5 ton anvil 5,9900 LS14B - a cartesian product
44 Jet Set 1 ton anvil 9,9900 LS14B - a cartesian product
45 Jet Set 2 ton anvil 14,9900 LS14B - a cartesian product
46 Jet Set Bird seed 10,0000 LS14B - a cartesian product
47 Jet Set Carrots 2,5000 LS14B - a cartesian product
48 Jet Set Detonator 13,0000 LS14B - a cartesian product
49 Jet Set Fuses 3,4200 LS14B - a cartesian product
50 Jet Set JetPack 1000 35,0000 LS14B - a cartesian product
51 Jet Set JetPack 2000 55,0000 LS14B - a cartesian product
52 Jet Set Oil can 8,9900 LS14B - a cartesian product
53 Jet Set Safe 50,0000 LS14B - a cartesian product
54 Jet Set Sling 4,4900 LS14B - a cartesian product
55 Jet Set TNT (1 stick) 2,5000 LS14B - a cartesian product
56 Jet Set TNT (5 sticks) 10,0000 LS14B - a cartesian product
57 Jouets Et Ours .5 ton anvil 5,9900 LS14B - a cartesian product
58 Jouets Et Ours 1 ton anvil 9,9900 LS14B - a cartesian product
59 Jouets Et Ours 2 ton anvil 14,9900 LS14B - a cartesian product
60 Jouets Et Ours Bird seed 10,0000 LS14B - a cartesian product
61 Jouets Et Ours Carrots 2,5000 LS14B - a cartesian product
62 Jouets Et Ours Detonator 13,0000 LS14B - a cartesian product
63 Jouets Et Ours Fuses 3,4200 LS14B - a cartesian product
64 Jouets Et Ours JetPack 1000 35,0000 LS14B - a cartesian product
65 Jouets Et Ours JetPack 2000 55,0000 LS14B - a cartesian product
66 Jouets Et Ours Oil can 8,9900 LS14B - a cartesian product
67 Jouets Et Ours Safe 50,0000 LS14B - a cartesian product
68 Jouets Et Ours Sling 4,4900 LS14B - a cartesian product
69 Jouets Et Ours TNT (1 stick) 2,5000 LS14B - a cartesian product
70 Jouets Et Ours TNT (5 sticks) 10,0000 LS14B - a cartesian product
71 LT Supplies .5 ton anvil 5,9900 LS14B - a cartesian product
72 LT Supplies 1 ton anvil 9,9900 LS14B - a cartesian product
73 LT Supplies 2 ton anvil 14,9900 LS14B - a cartesian product
74 LT Supplies Bird seed 10,0000 LS14B - a cartesian product
75 LT Supplies Carrots 2,5000 LS14B - a cartesian product
76 LT Supplies Detonator 13,0000 LS14B - a cartesian product
77 LT Supplies Fuses 3,4200 LS14B - a cartesian product
78 LT Supplies JetPack 1000 35,0000 LS14B - a cartesian product
79 LT Supplies JetPack 2000 55,0000 LS14B - a cartesian product
80 LT Supplies Oil can 8,9900 LS14B - a cartesian product
81 LT Supplies Safe 50,0000 LS14B - a cartesian product
82 LT Supplies Sling 4,4900 LS14B - a cartesian product
83 LT Supplies TNT (1 stick) 2,5000 LS14B - a cartesian product
84 LT Supplies TNT (5 sticks) 10,0000 LS14B - a cartesian product
   cust_id cust_name QNM
1 10001 Coyote Inc. LS14C - inner join
2 10003 Wascals LS14C - inner join
3 10004 Yosemite Place LS14C - inner join
   cust_id cust_name qnm
1 10001 Coyote Inc. LS14D - inner join #2
2 10003 Wascals LS14D - inner join #2
3 10004 Yosemite Place LS14D - inner join #2
   cust_id cust_name cust_contact qnm
1 10001 Coyote Inc. Y Lee LS14F - "INT2" select example as subquery
2 10004 Yosemite Place Y Sam LS14F - "INT2" select example as subquery
   cust_id cust_name cust_contact qnm
1 10001 Coyote Inc. Y Lee LS14G - "INT2" example as equi-join
2 10004 Yosemite Place Y Sam LS14G - "INT2" example as equi-join