R help - Mar 2004 - UNION

Hi,

I have a problem, can you help?

When i type:
 > library(RODBC)
 > a<-odbcConnect("oracle")
 > sqlQuery(a,"(select VALFACT>500 from EPISGDHS) UNION (select 
VALFACT<1000 from EPISGDHS)")

Comes the error:
[1] "S1000 923 [unixODBC][Easysoft][Oracle]ORA-00923: FROM keyword not 
found where expected at offset 15"
[2] "[RODBC] ERROR: Could not SQLPrepare"

Margarida Igreja.

using WinNT



	[[alternative HTML version deleted]]