Thanks, Jay,
That helped me refine it beautifully :-)
I love this feature of reportbuilder. I was able to eliminate the
relationship tables entirely and just do separate selects for the relevant
tables themselves, which cut out a ton of extra work!
Now I am going to attempt to repeat this with
Oh Oh! I hit Edit- Run SQL Directly and I'm getting much more informative
error messages - stand-by :-)
--
View this message in context:
http://nabble.documentfoundation.org/UNION-Query-throwing-error-tp3695780p3695882.html
Sent from the Users mailing list archive at Nabble.com.
--
For
One more requirement - in report builder properties, chose in general Query,
but Analize SQL:NO.
--
View this message in context:
http://nabble.documentfoundation.org/UNION-Query-throwing-error-tp3695780p3696191.html
Sent from the Users mailing list archive at Nabble.com.
--
For unsubscribe
Hi,
On 01/28/2012 12:51 PM, blesko wrote:
One more requirement - in report builder properties, chose in general Query,
but Analize SQL:NO.
--
View this message in context:
http://nabble.documentfoundation.org/UNION-Query-throwing-error-tp3695780p3696191.html
Sent from the Users mailing
This was my solution:
`( SELECT appointment.date AS Date, appointment.notes AS
Description, physician.lastname AS Comment,
TO_CHAR(appointment.time, 'HH24:MI:SS') AS Notes, 'Appt' AS Type
FROM pat_appt, appointment, physician, patient WHERE
pat_appt.appt_id = appointment.id AND patient.id =