Run Code  | Code Wall  | Users  | Misc  | Feedback  | About  | Login  | Theme  | Privacy 

Microsoft SQL Server T-SQL in 10 mn ~ Lesson 13 Subqueries vers. #5

Language: Editor: Layout:
View schema
Execution time: 0,14 sec, rows selected: 31, rows affected: 55, absolute service time: 0,33 sec  
edit mode |  history  | discussion
   order_num prod_id QueryName
1 20005 TNT2 LS13A
2 20007 TNT2 LS13A
   cust_id QueryName
1 10001 LS13B
2 10004 LS13B
   cust_id QueryName
1 10001 LS13C
2 10004 LS13C
   order_num QueryName
1 20005 LS13D
2 20007 LS13D
   cust_id QueryName
1 10001 LS13E
2 10004 LS13E
   cust_name cust_contact QueryName
1 Coyote Inc. Y Lee LS13F
2 Yosemite Place Y Sam LS13F
   cust_name cust_contact QueryName
1 Coyote Inc. Y Lee LS13G
2 Yosemite Place Y Sam LS13G
   orders QueryName
1 2 LS13H
   cust_name cust_state orders QueryName
1 Coyote Inc. MI 2 ls13I
2 E Fudd IL 1 ls13I
3 Mouse House OH 0 ls13I
4 Wascals IN 1 ls13I
5 Yosemite Place AZ 1 ls13I
   cust_name cust_state orders QueryName
1 Coyote Inc. MI 5 LS13J
2 E Fudd IL 5 LS13J
3 Mouse House OH 5 LS13J
4 Wascals IN 5 LS13J
5 Yosemite Place AZ 5 LS13J
   cust_id cust_name QueryName
1 10001 Coyote Inc. LS13K
2 10003 Wascals LS13K
3 10004 Yosemite Place LS13K
   cust_id cust_name QueryName
1 10001 Coyote Inc. LS13L
2 10003 Wascals LS13L
3 10004 Yosemite Place LS13L