It could be that it does not support project command in external sql. Not sure which type of database you are connecting to,
You can do the same like project by creating a temp table with the columns and then do an insert. --Create tablename (column definitions) Then do Insert into tablename select * FROM dbo.trace_vw USING * WHERE part_id = 'P7035826608102' and ID_Trace in (SELECT TRACE_ID from rb_trace_serv_disp_vw) Dan Goldberg From: [email protected] <[email protected]> On Behalf Of paul buckleyandassoc.com Sent: Tuesday, May 21, 2024 2:35 PM To: [email protected] Subject: [EXTERNAL] [RBASE-L] - Having Trouble with the SQL in a Project Statement You don't often get email from [email protected]<mailto:[email protected]>. Learn why this is important<https://aka.ms/LearnAboutSenderIdentification> 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]<mailto:[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]<mailto:[email protected]>. To view this discussion on the web visit https://groups.google.com/d/msgid/rbase-l/CH2PR17MB34795B606421CA4AABA7A0B0D4EA2%40CH2PR17MB3479.namprd17.prod.outlook.com<https://groups.google.com/d/msgid/rbase-l/CH2PR17MB34795B606421CA4AABA7A0B0D4EA2%40CH2PR17MB3479.namprd17.prod.outlook.com?utm_medium=email&utm_source=footer>. -- 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/BY3PR19MB5027691DC2AA93D0077EFCC6D4EA2%40BY3PR19MB5027.namprd19.prod.outlook.com.
