Skip to Content
Jan 19, 2016 at 05:33 AM

Using SQL - multiple bit of information



If anyone could please help 😕

I have a table called obsdef with a field called label(string) - I also have an another table called Observe with a field called Obs_String (String).

I want to get the information out of Obs_String, I have set the label in record selection to pick out what I want so for example part1

{ObsDef.Label} in ["part1"] this works and get the desired result in Obs_String.


I want get two bits of information {ObsDef.Label} in ["part1","service2"] with Obs_String.

The problem is that its creating two line / multiple lines I want them in column not a row like below

Customer name Part Service name 1 xyz qrs name 2 abc

As I have set it up I'm getting

Customer Name Part Service name 1 xyz name 1 qrs name 2 abc

I really hope someone can point me in the right direction