Vladimir, On Sun, 2011-06-26 at 16:57 +0000, Vladimir Drobyshevsky wrote:
> Have a nice day, Jay! > > > planas <jslozier <at> gmail.com> writes: > > > > > Hi Vladimir, > > > > ... > > > > > Is it possible to change the way of LO making relation's query or to > > > find an another way to solve my problem? > > > > > > Thank you in advance! > > > > > > P.S. I have no subscription to this mailing list so send your answers > > > to my address too, please! > > > > > > -- > > > Sincerelly yours, > > > Vladimir G. Drobyshevsky > > > Wanna call me? Do it right now: +7 912 2473415 > > > > > > > My limited experience with SQL suggests you should qualify the typeID > > fields to remove any ambiguity. I have had this problem when working > > directly the outside database and developing queries for it. If one did > > properly qualify the ambiguous fields you get a similar error message. > > > > Thank you for answer! > > You absolutelly right in your sugesstion, but WHERE clause is changed > automatically (by adding 'AND "typeID" = :link_from_ProductID' ) by LO, as I > wrote above. I would be very grateful if you can show me solution to change > it. > > -- > Sincerelly yours, > Vladimir G. Drobyshevsky > Wanna call me? Do it right now: +7 912 2473415 > > I will show my limited experience I would not use ". The dialect I am most familiar with does not normally use them. So my query would be written: SELECT invTypes.typeName AS Name, invTypes.description AS Description, invTypeMaterials.quantity AS Qty, invTypeMaterials.typeID FROM EDB.public.invTypes AS invTypes, EDB.public.invTypeMaterials AS invTypeMaterials WHERE invTypes.typeID = invTypeMaterials.materialTypeID I am not sure if another dialect SQL requires the ". I am looking at my reference book SQL Server. I would think the dialects would not very that much but I have surprised before. -- Jay Lozier jsloz...@gmail.com -- Unsubscribe instructions: E-mail to users+h...@global.libreoffice.org In case of problems unsubscribing, write to postmas...@documentfoundation.org 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