Does anyone have ideas on how to implement a stack using sql ????
Given the following tables and data:
create table stack( id integer primary key, value integer);
create table stackpop ( id integer primary key, value integer );
begin;
insert into stack values (1, 1234);
insert into stack values (2, 1234);
insert into stack values (6, 1234);
insert into stack values (9, 1234);
commit;
begin;
insert into stackpop values (12, 1234) ;
insert into stackpop values (14, 1234) ;
insert into stackpop values (18, 1234) ;
commit;
Do you have any ideas for a select that will return the stackpop and stack
I'ds paired as follows:
12 | 9
14 | 6
18 | 2
Thanks for your help!
ken