I am using open office base, the latest version, and wish to amalgamate three outer joins, one left and two right

SELECT * FROM `Persons` LEFT JOIN `Address` ON `Persons`.`Address_id` = `Address`.`Address_id`

SELECT `Email`.*, `Persons`.* FROM { OJ `Email` RIGHT OUTER JOIN `Persons` ON `Email`.`Person_id` = `Persons`.`Person_id` }

SELECT * FROM { OJ `Telephone numbers` RIGHT OUTER JOIN `Persons` ON `Telephone numbers`.`Person_id` = `Persons`.`Person_id` }

I have tried for most of today to resolve this problem I cannot do it. Any ideas anyone please!!!!!

This is pure "air code" and untested since I don't have a copy of Open Office at this location, but I'd start with:-PatP

pat
thanks for the attempt but it did not work

what was it that did not "work" did not give you what you wanted? syntax error? What Pat gave you is almost how you would write SQL to get the info as you requested. Your statement does nothing for those of us that could offer assistance to you.

Dave Nance

i copied and pasted the code into base and got the error message
"syntax error in sql expression

well as Pat said it was off the top of his head and may not work exactly as it was. Something like this should work and stop selecting all cols.