german@mafalda:~$ sqlite :memory:
SQLite version 2.8.17
Enter ".help" for instructions
sqlite> create table empleado(id integer primary key,
...> nombre varchar(50),
...> telefono varchar(20));
sqlite> create table departamento(dpto integer primary key,
...> empleado_id integer,
...> region varchar(20));
sqlite> insert into empleado values(1,'manuel','555-1234');
sqlite> insert into empleado values(2,'samantha','0800-bootycall');
sqlite> insert into departamento values (1,1,'microcentro');
sqlite> insert into departamento values (2,2,'zona roja');
sqlite> select a.nombre, a.telefono, b.region from empleado as a, departamento as b where b.empleado_id=a.id and nombre like "m%";
manuel|555-1234|microcentro
sqlite> .header on
sqlite> .m column
sqlite> select a.nombre, a.telefono, b.region from empleado as a, departamento as b where b.empleado_id=a.id and nombre like "m%";
a.nombre a.telefono b.region
---------- ---------- -----------
manuel 555-1234 microcentro
sqlite> select a.nombre as "nombre" , a.telefono as "telefono", b.region as "region" from empleado as a, departamento as b where b.empleado_id=a.id and nombre like "m%";
nombre telefono region
---------- ---------- -----------
manuel 555-1234 microcentro
sqlite>