How to put a list using select?

[RickSurf]

Look that example:

select
f.cd_atendimento Atendimento,
f.cd_reg_fat Conta,
f.dt_inicio Data
from
DBAMV.REG_FAT f
where
f.cd_remessa is null and
f.cd_tip_acom = &

 

[Marco Kalter]

For example:

select * from emp
where deptno = &<name="Department number"
                 list="select deptno from dept order by deptno">
order by empno