select * from tbl_static_pages as SP INNER JOIN tbl_static_pages_lang as SPL ON SP.i_pageID = SPL.i_parentId where SP.i_pageID=9 and SP.c_status='L' and SPL.i_langID = 1
Dhanuka Group has two Divisions
Dhanuka Agritech Ltd.
Dhanuka Laboratories Ltd.