Hello,



I can realize the following with a procedure, but with a view too?



We select some records in some tables and joins. In one Table, there are two
records with different values. So I have by grouping this two records every
time.



It is possible?:



Select a.field, b.field, (c.field record 1 and c.field record 2 in one
string) from tabelle a left join tabelle b on a.id = b.id..?



I think it cannot work, but perhaps. there are another option without a
stored procedure. Select in select?



Thank you.



Best regards



Olaf







[Non-text portions of this message have been removed]