SELECT * FROM products a CROSS JOIN sales b WHERE b.p_id=2
| p_id | product | price | sale_id | c_id | p_id | product | qty | store |
|---|---|---|---|---|---|---|---|---|
| 1 | Hard Disk | 80 | 4 | 4 | 2 | RAM | 2 | DEF |
| 1 | Hard Disk | 80 | 7 | 2 | 2 | RAM | 3 | ABC |
| 1 | Hard Disk | 80 | 8 | 3 | 2 | RAM | 2 | DEF |
| 2 | RAM | 90 | 4 | 4 | 2 | RAM | 2 | DEF |
| 2 | RAM | 90 | 7 | 2 | 2 | RAM | 3 | ABC |
| 2 | RAM | 90 | 8 | 3 | 2 | RAM | 2 | DEF |
| 3 | Monitor | 75 | 4 | 4 | 2 | RAM | 2 | DEF |
| 3 | Monitor | 75 | 7 | 2 | 2 | RAM | 3 | ABC |
| 3 | Monitor | 75 | 8 | 3 | 2 | RAM | 2 | DEF |
| 4 | CPU | 55 | 4 | 4 | 2 | RAM | 2 | DEF |
| 4 | CPU | 55 | 7 | 2 | 2 | RAM | 3 | ABC |
| 4 | CPU | 55 | 8 | 3 | 2 | RAM | 2 | DEF |
| 5 | Keyboard | 20 | 4 | 4 | 2 | RAM | 2 | DEF |
| 5 | Keyboard | 20 | 7 | 2 | 2 | RAM | 3 | ABC |
| 5 | Keyboard | 20 | 8 | 3 | 2 | RAM | 2 | DEF |
| 6 | Mouse | 10 | 4 | 4 | 2 | RAM | 2 | DEF |
| 6 | Mouse | 10 | 7 | 2 | 2 | RAM | 3 | ABC |
| 6 | Mouse | 10 | 8 | 3 | 2 | RAM | 2 | DEF |
| 7 | Motherboard | 50 | 4 | 4 | 2 | RAM | 2 | DEF |
| 7 | Motherboard | 50 | 7 | 2 | 2 | RAM | 3 | ABC |
| 7 | Motherboard | 50 | 8 | 3 | 2 | RAM | 2 | DEF |
| 8 | Power supply | 20 | 4 | 4 | 2 | RAM | 2 | DEF |
| 8 | Power supply | 20 | 7 | 2 | 2 | RAM | 3 | ABC |
| 8 | Power supply | 20 | 8 | 3 | 2 | RAM | 2 | DEF |
Subhendu Mohapatra
Author & Instructor at plus2net
I write and maintain practical tutorials on Python, PHP, SQL, JavaScript, HTML, jQuery, and web development at plus2net. The tutorials focus on clear explanations, working examples, and code that readers can test and adapt while learning.
Connect:
Subscribe to our YouTube Channel here
This article is written by plus2net.com team.
https://www.plus2net.com
SQL Video Tutorials