The "dbo." was part of my table name. I detached the table and attempted to re-sattach it with an alias "vwBGProjectInfoTop" and use the following statement.
select * from vwBGProjectInfoTop t1, ValidStates t2 where t1.state = t2.st I still get the error. -----Original Message----- From: [email protected] [mailto:[email protected]] On Behalf Of A. Razzak Memon Posted At: Friday, April 03, 2009 4:12 PM Posted To: RB7-L Conversation: [RBASE-L] - Re: Multi Table Select Subject: [RBASE-L] - Re: Multi Table Select At 04:42 PM 4/3/2009, Charles Parks wrote: >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.vwBGProject >InfoTopLevel 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 Charlie, Once the server table is SATTACHed successfully, there is no need to add the "dbo." option to your sattached server table. Try the SELECT command as you would for a native R:BASE table and see what you get. Hope that helps! Very Best R:egards, Razzak.
