When I try to do a multi table select with a SQL Server table and R:Base table I get an error. [Microsoft][ODBC SQL Server Driver]Operation invalid at this time.
If I just browse from the table it shows data just fine. This is my select statement: select * from dbo.vwBGProjectInfoTopLevel t1, ValidStates t2 where t1.state = t2.st This select statement returns result but goes s..l..o..w..l...y...: select * from dbo.vwBGProjectInfoTopLevel where state in (select st from validstates) This goes quickly but is limited" select * from dbo.vwBGProjectInfoTopLevel where state = .fminst
