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

Microsoft SQL Server T-SQL in 10 mn ~ Lesson 13 Subqueries samples...

Language: Layout:
View schema
Execution time: 0,14 sec, rows selected: 31, rows affected: 55, absolute service time: 0,31 sec 
edit mode |  history  | discussion
   order_num prod_id
1 20005 TNT2
2 20007 TNT2
   cust_id
1 10001
2 10004
   cust_id
1 10001
2 10004
   order_num
1 20005
2 20007
   cust_id
1 10001
2 10004
   cust_name cust_contact
1 Coyote Inc. Y Lee
2 Yosemite Place Y Sam
   cust_name cust_contact
1 Coyote Inc. Y Lee
2 Yosemite Place Y Sam
   orders
1 2
   cust_name cust_state orders
1 Coyote Inc. MI 2
2 E Fudd IL 1
3 Mouse House OH 0
4 Wascals IN 1
5 Yosemite Place AZ 1
   cust_name cust_state orders
1 Coyote Inc. MI 5
2 E Fudd IL 5
3 Mouse House OH 5
4 Wascals IN 5
5 Yosemite Place AZ 5
   cust_id cust_name
1 10001 Coyote Inc.
2 10003 Wascals
3 10004 Yosemite Place
   cust_id cust_name
1 10001 Coyote Inc.
2 10003 Wascals
3 10004 Yosemite Place