Hi
i want to show in a select field, how many rooms free. For that, i need a subselect:
SELECT `Zimmer`.`ZimmerId`, sc_concat(`Zimmer`.`Gebaeude`,': ',`Zimmer`.`ZimmerNr`,' (',(SELECT COUNT(`ZimmerId`) FROM `TnZimmerLnk` WHERE `TnZimmerLnk`.`ZimmerId`=`Zimmer`.`ZimmerId`),'/',`AnzahlPersonen`,')') FROM `Zimmer` ORDER BY `Zimmer`.`Gebaeude`
This not work. If i do the same statement with a concat instead of sc_concat, everything work?
What is the advantage of sc_concat compared with concat?
Best regards
Steve