https://bugs.documentfoundation.org/show_bug.cgi?id=118492

--- Comment #1 from Drew Jensen <[email protected]> ---
Created attachment 143261
  --> https://bugs.documentfoundation.org/attachment.cgi?id=143261&action=edit
query after change

I'm using a fresh postgresql 10 install on Ubuntu 18.04 and Libo with
postgres:SDBC. 

Created the three tables and a few records.

SELECT "SP"."id", "SP"."hämo", "S"."situation" 
FROM "situation_p" "SP", "situation" "S" 
WHERE "SP"."situation" = "S"."id"

got just the output you did in Base

changed it to: 

SELECT "SP"."id", "SP"."hämo", "S"."situation" 
FROM "situation_p" "SP", "situation" "S" 
WHERE "S"."id" = "SP"."situation"

and get what seems to be what you are looking for. (screen shot attached)

-- 
You are receiving this mail because:
You are the assignee for the bug.
_______________________________________________
Libreoffice-bugs mailing list
[email protected]
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

Reply via email to