AnsweredAssumed Answered

Add text to beginning of each sql calc

Question asked by MartinBishop on Sep 12, 2016
Latest reply on Sep 12, 2016 by beverly

Trying to add text to sql as shown below... I've tried substitute (list ( ) ) but with no luck, close but no cigar

 

ExecuteSQL ( "

SELECT Person, Place ¶

FROM Spaces INNER JOIN Person  ¶

ON Spaces.\"_fkPersonID\" = Person.\"__PersonID\" ¶

WHERE Spaces.\"_fkPlacesID\" = ?

ORDER BY \"__PersonID\" DESC ";

": "; "¶" ;

__PlacesID ) ;

 

Outputs

John: Home

Bob: Office

 

Trying to get

- John: Home

- Bob: Office

- Blah: Blah

Outcomes