Re: How do I get a single resultset back using Cayenne

You are essentially wanting a "select * from Procedure"? /dev/mrg On 2/4/07, Frank Rocco <[EMAIL PROTECTED]> wrote: Hello, I need to display a table that shows all procedures with a column that says if there is a schedule for the current date and what provider is assigned. Procedure Table p

How do I get a single resultset back using Cayenne

Hello, I need to display a table that shows all procedures with a column that says if there is a schedule for the current date and what provider is assigned. Procedure Table procedure_id (PK) procedure_name Provider Table provider_id (PK) provider_name Schedule Table schedule_id (PK) schedu