[libreoffice-users] UNION Query throwing error

Hello!

Wonder if my error jumps out at any of you - attempting to get a 3 column
result - would you take a look?

`( SELECT "appointment"."date" AS "Date", "physician"."lastname" AS
"Description", "appointment"."time" AS "Comment" FROM "pat_appt",
"appointment", "physician", "patient" WHERE "pat_appt"."appt_id" =
"appointment"."id" AND "patient"."id" = "pat_appt"."pat_id" ) UNION ( SELECT
"prescription"."next_fill_date" AS "Date", "medicines"."generic" AS
"Description", "pharmacy"."name" AS "Comment" FROM "pat_med",
"prescription", "pharmacy", "medicines", "patient" WHERE
"pat_med"."presc_id" = "prescription"."id" AND "patient"."id" =
"pat_med"."pat_id" AND "medicines"."id" = "prescription"."medication" AND
"pharmacy"."id" = "prescription"."pharm_id" ) UNION ( SELECT "bill"."due" AS
"Date", "bill"."descrip" AS "Description", "bill"."amount" AS "Comment" FROM
"pat_bill", "bill", "patient" WHERE "pat_bill"."bill_id" = "bill"."id" AND
"patient"."id" = "pat_bill"."pat_id" ) UNION ( SELECT "immunizations"."due"
AS "Date", "immunizations"."description" AS "Description",
"immunizations"."date" AS "Comment" FROM "pat_immun", "immunizations",
"patient" WHERE "pat_immun"."imun_id" = "immunizations"."id" AND
"patient"."id" = "pat_immun"."pat_id" ) ORDER BY 1 ASC, 4 ASC, 7 ASC, 10
ASC`

The error is 
SQL Status: HY000
Error code: 1000

syntax error, unexpected $end, expecting BETWEEN or IN or SQL_TOKEN_LIKE

I'm attaching the relationships.

http://nabble.documentfoundation.org/file/n3695780/08.png 

Any suggestions?

Beth

--
View this message in context: 
http://nabble.documentfoundation.org/UNION-Query-throwing-error-tp3695780p3695780.html
Sent from the Users mailing list archive at Nabble.com.

-- 
For unsubscribe instructions e-mail to: users+help@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted