huimv-baqing/sql/biz_v_livestock_resource.sql

create or replace view v_livestock_resource as
select resource_name as title,introduction,resource_type as type,photo_file_url as cover_file_url,null as content_file_url,publish_time from biz_medical_resource where del_flag='0' and publish_status=1 and resource_type='004002'
UNION ALL
select resource_name as title,introduction,resource_type as type,cover_file_url,video_file_url as content_file_url,publish_time from biz_tech_resource where del_flag='0' and publish_status=1 and resource_type in ('004006','004008')
UNION ALL
select resource_name as title,introduction,resource_type as type,photo_file_url as cover_file_url,video_file_url as content_file_url,publish_time from biz_tech_resource where del_flag='0' and publish_status=1 and resource_type='004007';