1

I'm learning LibreOffice Base (3.6.2). Unfortunatly the doc is pretty poor. The DB is a ".odb" file format. Here's a simple multi-table query:

LibreOffice Base query

I'd like to merge the field "refLogiciel.name" and "tblPosteLogiciel.version" in one field.

Thank you!

Sirber
  • 3,358
  • 5
  • 25
  • 32

2 Answers2

0

You will have to Create the query in SQL for that one. I have the same problem. No answers yet, but I do at least have some headway in that area. Here's a link to my question, which might help:

Error in Querying Concatenation of 2 fields in LibreOffice Base SQL

EDIT: Oops, I din't realize how old this post was. Hope you found out how to do it so you can share it to me. :)

Community
  • 1
  • 1
Kevin CA
  • 25
  • 1
  • 7
0

use as field: CONCAT( "refLogiciel"."name" , "tblPosteLogiciel"."version") If you want a space between the two then use: CONCAT( "refLogiciel"."name" , CONCAT( ' ', "tblPosteLogiciel"."version"))

ilias iliadis
  • 601
  • 8
  • 15