Good afternoon, It’s been the longest time since I’ve reached out to this group for help, I’ve been beating my head against the wall doing mostly SQL stuff. I’m so glad to be back on this RBASE project. I am using the latest version, 11.0.1.40516. I’m trying to improve the performance of a PROJECT statement that uses an SATTACHED SQL view (dbo.trace_vw) and another RBASE table created by projecting from an SATTACHED SQL view (rb_trace_serv_disp_vw). The column Part_ID is common to both tables and ID_Trace is in dbo.trace_vw and TRACE_ID is in rb_trace_serv_disp_vw. If I run just the Select statement (SELECT TRACE_ID from rb_trace_serv_disp_vw) I get the list I’m looking for. If I run the entire project statement as shown below, it generates a table with no rows. I’ve been back and forth over this to where m eyes are just getting crossed. Am I missing something obvious?
Any help my current case of “Blues Clues” would be greatly appreciated. PROJECT rb_trace_vw2 FROM dbo.trace_vw USING * WHERE part_id = 'P7035826608102' and ID_Trace in (SELECT TRACE_ID from rb_trace_serv_disp_vw) Thanks in advance, Paul Buckley [email protected] -- For group guidelines, visit http://www.rbase.com/support/usersgroup_guidelines.php --- You received this message because you are subscribed to the Google Groups "RBASE-L" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To view this discussion on the web visit https://groups.google.com/d/msgid/rbase-l/CH2PR17MB34795B606421CA4AABA7A0B0D4EA2%40CH2PR17MB3479.namprd17.prod.outlook.com.
