[sqlite] Re: SQL Challenge, select stack

[Igor Tandetnik]

Ken <kennethinbox-sqlite-/[EMAIL PROTECTED]> wrote:
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);
insert into stack values (22, 1234);

 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 id's paired as follows:
     12 | 9
     14 | 6
     18 | 2

What's the logic supposed to be here? Why is the stack record with id=22 
omitted?

I believe I've answered this question the first time you aked it. Have 
you found the answer lacking? In what respect?

Igor Tandetnik 


-----------------------------------------------------------------------------
To unsubscribe, send email to [EMAIL PROTECTED]
-----------------------------------------------------------------------------