I am facing some problem in a query. I have two table tbl_summary and publishinfo.
I want to display data through join from both tables. Display data must be multiple same record display one record and which that stored single record then single record also displayed. In both tables common are artid and catid. publishinfo table only contains artid and catid columns. All details are stored in tbl_sumary table.
Please suggest and help me.