Gunner Yes, but these are variables generated from another commad file run prior to this. The actual column in the table master is cdiinv. Steve
-----Original Message----- From: [email protected] [mailto:[EMAIL PROTECTED] Behalf Of Gunnar Ekblad Sent: Tuesday, March 18, 2008 7:13 AM To: RBASE-L Mailing List Subject: [RBASE-L] - SV: Help with Where clause Where cdinv between .vinvoice1 and .vinvoce2 Is that what you looking for? Gunnar Ekblad Kontema IT AB Hästholmsvägen 32 S-131 30 NACKA SWEDEN +46 070 545 50 38 [EMAIL PROTECTED] -----Ursprungligt meddelande----- Från: [email protected] [mailto:[EMAIL PROTECTED] För Steve Breen Skickat: den 18 mars 2008 12:01 Till: RBASE-L Mailing List Ämne: [RBASE-L] - Help with Where clause Here is my problem. I am trying to project a view based on to variables. vinvoice1 and vinovice2 I need to select all rows as follows where cdinv includes these recorods and all those in between. Just can't figure out how to design the were clause. Any help is appreciated. Stephen Breen CDI Services, Inc. Road Support Division DROP VIEW atvinv_master_cust CREATE TEMP VIEW atvinv_master_cust AS SELECT + address1 + address2 + billadd1 + billattn + billcity + billdate + billname + billst + billtitl + billzip + breakdat + cause + cdiinv + country + custappv + custattn + custcity + custname + custnub2 + custphon + custpo + custstat + custtilt + custzip + datasource + disparts + doornam + drivname + drivtime + drn + estlabor + estpart + estsc + esttire + faxn + finalnm + hours + hub + hub2 + macola + mileest + miles + nabpo + parentcustid + pofax + pon + problem + reefer + remedy + shopest + timein + timetot + tractor_plate + tractor_state + tractorn + tractyr + tracvin + trailer_plate + trailer_state + trailern + trctmake + trlmake + trlvin + trlyear + vehcity + vehstate + vehstrt + FROM master t1, customer t2 WHERE t1.custnub2 = t2.custnub2 DROP attinv_master_cust PROJECT TEMP attinv_master_cust FROM atvinv_master_cust USING * + WHERE cdiinv = .vinvoice1 and cdiinv = vinvioce2 CREATE INDEX #none ON `attinv_master_cust` (`pon` ASC) CREATE INDEX #none ON `attinv_master_cust` (`billdate` ASC) RETURN
