SELECT * FROM products a CROSS JOIN sales b WHERE b.p_id=2

p_idproductpricesale_idc_idp_idproductqtystore
1Hard Disk80442RAM2DEF
1Hard Disk80722RAM3ABC
1Hard Disk80832RAM2DEF
2RAM90442RAM2DEF
2RAM90722RAM3ABC
2RAM90832RAM2DEF
3Monitor75442RAM2DEF
3Monitor75722RAM3ABC
3Monitor75832RAM2DEF
4CPU55442RAM2DEF
4CPU55722RAM3ABC
4CPU55832RAM2DEF
5Keyboard20442RAM2DEF
5Keyboard20722RAM3ABC
5Keyboard20832RAM2DEF
6Mouse10442RAM2DEF
6Mouse10722RAM3ABC
6Mouse10832RAM2DEF
7Motherboard50442RAM2DEF
7Motherboard50722RAM3ABC
7Motherboard50832RAM2DEF
8Power supply20442RAM2DEF
8Power supply20722RAM3ABC
8Power supply20832RAM2DEF
CROSS JOIN LEFT JOIN using Multiple Tables


plus2net.com






Post your comments , suggestion , error , requirements etc here





SQL Video Tutorials










We use cookies to improve your browsing experience. . Learn more
HTML MySQL PHP JavaScript ASP Photoshop Articles FORUM . Contact us
©2000-2021 plus2net.com All rights reserved worldwide Privacy Policy Disclaimer