hope this helps

CREATE TABLE store

(

storeno varchar(3) NULL,

delday varchar(3) NULL

) ON [PRIMARY]

insert into store values ('01','Tue')

create table orders

( store varchar(2) null,

orderno varchar(3) null,

orderdate varchar(10) null,

deldate varchar(10) null)

insert into orders values...