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
--- RBASE-L
================================================
TO POST A MESSAGE TO ALL MEMBERS:
Send a plain text email to [email protected]
(Don't use any of these words as your Subject:
INTRO, SUBSCRIBE, UNSUBSCRIBE, SEARCH,
REMOVE, SUSPEND, RESUME, DIGEST, RESEND, HELP)
================================================
TO SEE MESSAGE POSTING GUIDELINES:
Send a plain text email to [email protected]
In the message SUBJECT, put just one word: INTRO
================================================
TO UNSUBSCRIBE:
Send a plain text email to [email protected]
In the message SUBJECT, put just one word: UNSUBSCRIBE
================================================
TO SEARCH ARCHIVES:
Send a plain text email to [email protected]
In the message SUBJECT, put just one word: SEARCH-n
(where n is the number of days). In the message body,
place any
text to search for.
================================================
