view_livros

view_livros

SELECT
	mer.a_codmer
	,upper(mer.a_desmer::text) AS a_desmer
	,mer.a_preven
	,upper(mer.a_nomaut::text) AS a_nomaut
	,upper(sel.a_nomsel::text) AS a_nomsel
	,sel.a_codsel
	,upper(are.a_nomare::text) AS a_nomare
	,mer.a_periodo
	,mer.a_codref
	,btrim(are.a_codref::text) AS a_codcat
	,mer.a_datcad
	,mer.a_codisbn
	,mer.a_sinmer
	,mer.a_maiven
	,mer.a_livdes
	,mer.a_stamer
	,sel.a_selati
FROM
	ses_mer mer
	,ses_sel sel
	,ses_are are
WHERE
	mer.a_preven > 0::numeric AND
	sel.a_codsel = mer.a_codsel AND
	are.a_codare = mer.a_codare AND
	mer.a_desmer::text <> ''::text AND
	mer.a_nomaut::text <> ''::text AND
	are.a_nomare::text <> ''::text AND
	mer.a_codare::text <> '00000'::text AND
	mer.a_codsel > 0 AND
	sel.a_selati = 1;