[RBASE-L] - Re: SQL Query question

[Jason Kramer]

Thanks for the suggestion, but that generated the same correlation error.                                                     Thanks,                                                     Jason Jason Kramer University Archives and Records Management 002 Pearson Hall (302) 831 - 3127 (voice) (302) 831 - 6903 (fax) On 11/21/2012 12:46 PM, Albert Berry wrote: Try the query without the SELECT after BROWSE. R:Base syntax is BROWSE rg_id etc. Albert On 21/11/2012 9:44 AM, Jason Kramer wrote: BROWSE SELECT rg_id,rg_name,T1.status_name AS rg_status,schedule_id,sched_name,T2.status_name AS sched_status,series_id,ser_name,T3.status_name AS ser_status FROM (record_group T1 LEFT OUTER JOIN schedule T2 ON T1.rg_id=T2.rg_id) J1 LEFT OUTER JOIN series T3 ON J1.schedule_id=T3.schedule_id