I have a table like this

CREATE TABLE LSV (
ART_CODICE VARCHAR(20) DEFAULT '' ,
DESCRIZIONE VARCHAR(40),
DATA_ORA TIMESTAMP DEFAULT CURRENT_TIMESTAMP,
PREZZO NUMERIC(18,6) DEFAULT 0

);


INSERT INTO TABLE_NAME (ART_CODICE, DESCRIZIONE1, DATA_ORA, PREZZO) VALUES
('25-OCT-2008 05:18:40', 'CDC.KR.XQ', 'POWER LINE KRAUN 200MBPS BRIDGE
HOMEPLUG', 65);
INSERT INTO TABLE_NAME (ART_CODICE, DESCRIZIONE1, DATA_ORA, PREZZO) VALUES
('25-OCT-2008 05:18:40', 'CDC.ZY.66', 'ROUTER ADSL2+ ZYXEL WI-FI PRESTIGE
660HW', 79);
INSERT INTO TABLE_NAME (ART_CODICE, DESCRIZIONE1, DATA_ORA, PREZZO) VALUES
('30-MAR-2009 08:47:16', 'CDC.HS.14', 'STAMPANTE HP DESKJET 6940', 90);
INSERT INTO TABLE_NAME (ART_CODICE, DESCRIZIONE1, DATA_ORA, PREZZO) VALUES
('20-APR-2009 13:48:09', 'CDC.86.HV', 'NB HP PAVILION DV7-1110EL', 930);
INSERT INTO TABLE_NAME (ART_CODICE, DESCRIZIONE1, DATA_ORA, PREZZO) VALUES
('20-APR-2009 13:53:16', 'CDC.KR.3W', 'KRAUN KIT ROUTER ADSL2/2+ WI-FI +
USBKEY', 59);
INSERT INTO TABLE_NAME (ART_CODICE, DESCRIZIONE1, DATA_ORA, PREZZO) VALUES
('20-APR-2009 13:55:11', 'CDC.SE.23', 'HDD SEAGATE 160GB PATA 7200RPM',
42.5);
INSERT INTO TABLE_NAME (ART_CODICE, DESCRIZIONE1, DATA_ORA, PREZZO) VALUES
('20-APR-2009 13:56:57', 'CDC.WD.86', 'HDD ESTERNO WD MY BOOK ESSENTIAL
1TB', 105);

When I try to run this SQL code:

Select Art.DATA_ORA,Art.Codice,Art.Descrizione1,Lsv.Prezzo from Lsv,ART
where LSV.ART_CODICE=ART.CODICE
AND LSV.DATA_ORA between CAST('03/20/2009 00:01:00' AS TIMESTAMP) and
CAST('04/20/2009 23:59:00' AS TIMESTAMP)
ORDER BY DATA_ORA


I obtain

DATA_ORA CODICE DESCRIZIONE1 PREZZO
25/10/2008 5.18.40 CDC.KR.XQ POWER LINE KRAUN 200MBPS
BRIDGE HOMEPLUG 65
25/10/2008 5.18.40 CDC.ZY.66 ROUTER ADSL2+ ZYXEL WI-FI
PRESTIGE 660HW 79
30/03/2009 8.47.16 CDC.HS.14 STAMPANTE HP DESKJET 6940
90
20/04/2009 13.48.09 CDC.86.HV NB HP PAVILION
DV7-1110EL 930
20/04/2009 13.53.16 CDC.KR.3W KRAUN KIT ROUTER
ADSL2/2+ WI-FI + USBKEY 59
20/04/2009 13.55.11 CDC.SE.23 HDD SEAGATE 160GB
PATA 7200RPM 42,5
20/04/2009 13.56.57 CDC.WD.86 HDD ESTERNO WD MY
BOOK ESSENTIAL 1TB 105

I don't have to retrieve first two lines?
Any idea?


Codebue Fabio
.--------------------------------.
P-Soft di Codebue Fabio & C. sas
via B.Storti, 19
24060 Chiuduno - BG
Phone: +39.035.839435
Mobile: +39.348.3515786
Fax: +39.030.5100306
.-----------------------------.
Web : www.p-soft.biz
EMail: f.codebue@...