All pastes #630227 Raw Edit

Mine

public text v1 · immutable
·published 2007-07-23 00:21 UTC
rendered paste body
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>