use mm64;

/*
system echo The databases are
show databases;
*/

create table last (
	name varchar(100) not null
);

create table first (
	last varchar(100) not null references last(name),
	name varchar(100) not null
);

insert into last (name) values ('Meretzky');
insert into last (name) values ('Wortner');

insert into first (name, last) values ('Mark', 'Meretzky');
insert into first (name, last) values ('Steven', 'Meretzky');
insert into first (name, last) values ('Frank', 'Wortner');
insert into first (name, last) values ('Maureen', 'Wortner');

select first.name, last.name from last, first
where first.last = last.name;

/*
column first(name) format 'a25';
column name format a25
column phone_number format a12
set feedback on
*/

drop table first;
drop table last;
quit