mysql - I have joined 4 tables in sql , Is it correct or not ? please verify the code -


below query executed selecting price , size along brand , category, sub-category name db

select c.cname     ,sc.scname     ,b.bname     ,p.size     ,p.price (     (         (             price p inner join category c on p.c_id = c.c_id             ) inner join subcategory sc on p.sc_id = sc.sc_id         ) inner join brand b on p.b_id = b.p_id     ) 


Comments

Popular posts from this blog

ZeroMQ on Windows, with Qt Creator -

unity3d - Unity SceneManager.LoadScene quits application -

python - Error while using APScheduler: 'NoneType' object has no attribute 'now' -