SELECT * FROM products CROSS JOIN sales WHERE qty=2

p_idproductpricesale_idc_idp_idproductqtystore
1Hard Disk80123Monitor2ABC
1Hard Disk80442RAM2DEF
1Hard Disk80633Monitor2DEF
1Hard Disk80832RAM2DEF
1Hard Disk80923Monitor2ABC
2RAM90123Monitor2ABC
2RAM90442RAM2DEF
2RAM90633Monitor2DEF
2RAM90832RAM2DEF
2RAM90923Monitor2ABC
3Monitor75123Monitor2ABC
3Monitor75442RAM2DEF
3Monitor75633Monitor2DEF
3Monitor75832RAM2DEF
3Monitor75923Monitor2ABC
4CPU55123Monitor2ABC
4CPU55442RAM2DEF
4CPU55633Monitor2DEF
4CPU55832RAM2DEF
4CPU55923Monitor2ABC
5Keyboard20123Monitor2ABC
5Keyboard20442RAM2DEF
5Keyboard20633Monitor2DEF
5Keyboard20832RAM2DEF
5Keyboard20923Monitor2ABC
6Mouse10123Monitor2ABC
6Mouse10442RAM2DEF
6Mouse10633Monitor2DEF
6Mouse10832RAM2DEF
6Mouse10923Monitor2ABC
7Motherboard50123Monitor2ABC
7Motherboard50442RAM2DEF
7Motherboard50633Monitor2DEF
7Motherboard50832RAM2DEF
7Motherboard50923Monitor2ABC
8Power supply20123Monitor2ABC
8Power supply20442RAM2DEF
8Power supply20633Monitor2DEF
8Power supply20832RAM2DEF
8Power supply20923Monitor2ABC
CROSS JOIN LEFT JOIN using Multiple Tables
Subscribe to our YouTube Channel here


Subscribe

* indicates required
Subscribe to plus2net

    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-2024 plus2net.com All rights reserved worldwide Privacy Policy Disclaimer