query

calamaris · #1 (**permalink**) 08-29-10, 13:15

hi . i have this table and i want to create a query for identify any instrument(s) that have not been returned past their rental due date

create table InstStatus( InstStatus_ID integer not null primary key,
InstStatus_available varchar(20),
InstStatus_IssueDate Date,
InstStatus_ExpDate Date,
InstStatus_DurDate integer,
Cust_ID integer,
Inst_SN integer);

Lenny77 · #2 (**permalink**) 08-30-10, 15:29

It could be something like following query:

Code:

select * from InstStatus
Where InstStatus_ExpDate < current date
  and InstStatus_ExpDate < InstStatus_IssueDate + InstStatus_DurDate day
;

Lenny

Internet Services

Web Development

Digital Marketing

Consumer Tech