useful-qry/function-in-db/views/igroup_item_thm_view.sql

create or replace view igroup_item_thm_view as 
select
	dbr_item.*, igroup_code, igroup_name,
	media_id1, media_id2, media_id3, media_id4, media_id5,
	pc1, pc2, pc3, pc4, pc5, pc6, pc7, pc8, pc9, pc10,   
	pd1, pd2, pd3, pd4, pd5, pd6, pd7, pd8, pd9, pd10
from
	dbr_item
	inner join dbr_igroup on dbr_item.igroup_id = dbr_igroup.id
	inner join dbr_item_thm on dbr_item.id = dbr_item_thm.id;