Re: [libreoffice-users] Re: LOBase Query - Left or Right Join? - RESOLVED

2016-01-06 Thread Don Parris
On Tue, Jan 5, 2016 at 5:15 PM, wrote: > Don Parris wrote: > >> Still trying to work out the OUTER JOIN syntax apparently. I tried a >> simpler outer join statement: >> SELECT >> "tCoreType"."type" "Type", "tCoreCategory"."category" "Category" >> FROM {oj

Re: [libreoffice-users] Re: LOBase Query - Left or Right Join?

2016-01-05 Thread libreoffice-ml . mbourne
Don Parris wrote: Still trying to work out the OUTER JOIN syntax apparently. I tried a simpler outer join statement: SELECT "tCoreType"."type" "Type", "tCoreCategory"."category" "Category" FROM {oj "tCoreType" "ctype" LEFT OUTER JOIN "tCoreCategory" "ccat" ON "ctype"."type_id" =

Re: [libreoffice-users] Re: LOBase Query - Left or Right Join?

2016-01-04 Thread Don Parris
On Sat, Jan 2, 2016 at 4:36 AM, Luuk wrote: > > > On 01-01-16 22:08, Paul Steyn wrote: > >> Hi Don, >> > > > You are absolutely right, but the *syntax* is different in LO >> > see link i posted earlier > > > > > Still trying to work out the OUTER JOIN syntax apparently.

Re: [libreoffice-users] Re: LOBase Query - Left or Right Join?

2016-01-02 Thread Luuk
On 01-01-16 22:08, Paul Steyn wrote: Hi Don, Your SELECT statement is indeed incorrect; it seems as though you don't fully understand joins (I could be mistaken, but your syntax is off by enough to suggest this). Firstly, choose a format for your SELECT statement to make it easier to read.

Re: [libreoffice-users] Re: LOBase Query - Left or Right Join?

2016-01-02 Thread Don Parris
On Fri, Jan 1, 2016 at 1:18 PM, Luuk wrote: > reply below > >> >> > > This was the second link i gave you > > it says: > Example > |select Article.* from {oj item LEFT OUTER JOIN orders ON item.no > =orders.ANR} > > The link was: > >

Re: [libreoffice-users] Re: LOBase Query - Left or Right Join?

2016-01-02 Thread Don Parris
On Sat, Jan 2, 2016 at 4:36 AM, Luuk wrote: > > > On 01-01-16 22:08, Paul Steyn wrote: > >> Hi Don, >> >> Your SELECT statement is indeed incorrect; it seems as though you don't >> fully understand joins (I could be mistaken, but your syntax is off >> by enough to suggest

Re: [libreoffice-users] Re: LOBase Query - Left or Right Join?

2016-01-01 Thread Paul Steyn
Hi Don, Your SELECT statement is indeed incorrect; it seems as though you don't fully understand joins (I could be mistaken, but your syntax is off by enough to suggest this). Firstly, choose a format for your SELECT statement to make it easier to read. I've reformatted it below using one such

[libreoffice-users] Re: LOBase Query - Left or Right Join?

2016-01-01 Thread Don Parris
Update: I did try re-writing the query with LEFT/RIGHT JOINS, but all I get are syntax errors. Maybe I have my SQL statement incorrect? SELECT "tCoreCategory"."category", "tCntEntity"."entity_name", "tCntPerson"."first_name", "tCntPerson"."last_name", "tCntAddress"."location_name",

Re: [libreoffice-users] Re: LOBase Query - Left or Right Join?

2016-01-01 Thread Luuk
reply below On 01-01-16 18:06, Don Parris wrote: Update: I did try re-writing the query with LEFT/RIGHT JOINS, but all I get are syntax errors. Maybe I have my SQL statement incorrect? SELECT "tCoreCategory"."category", "tCntEntity"."entity_name", "tCntPerson"."first_name",