Databases
StackOverflow2013
Postsdbo
POSQL query for "concatenate on join"
 

Note that there are some explanatory texts on larger screens.

plurals
  1. POSQL query for "concatenate on join"
    primarykey
    data
    text
    <p>I'm using a <strong>Sybase ASE</strong> database.<br> I have two tables that look like:</p> <p>Table <code>Shops</code>: </p> <pre><code>--------------------- | ShopName | ShopID | --------------------- | Sweetie | 1 | | Candie | 2 | | Sugarie | 3 | --------------------- </code></pre> <p>Table <code>Sweets</code>:</p> <pre><code>---------------------- | SweetName | ShopID | ---------------------- | lolly | 1 | | redlolly | 1 | | greenloly | 1 | | taffy | 2 | | redtaffy | 2 | | bluetaffy | 2 | | choco | 3 | | mintchoco | 3 | | milkchoco | 3 | | gummybees | 3 | ---------------------- </code></pre> <p>I want to write a query that would generate a result that looks like:</p> <pre><code>----------------------------------------------------- | ShopName | Sweets | ----------------------------------------------------- | Sweetie | lolly, redlolly, greenlolly | | Candie | taffy, redtaffy, bluetaffy | | Sugarie | choco, mintchoco, milkchoco, gummybees | ----------------------------------------------------- </code></pre> <p>How should I go about doing that? I need this for a Sybase ASE database. I tried the <code>LIST()</code> function, but I'm getting an error on that. I checked its documentation, and turns out, this function is not available in the ASE Edition.</p> <p>This probably means that there will be some "dynamic sql" involved (I have very little idea what that means). Can anyone help?</p> <p>I could want <code>ShopId</code> instead of <code>ShopName</code> in the results table... I don't know for sure yet. I guess that won't be much of a difference. Also, trailing commas in <code>Sweets</code> column of results is not an issue. All I want is a non-whitespace separator.</p>
    singulars
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. PTQuestion
    1. USAndrew Arnold
    1. USjrharshath
    plurals
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. PO
      singulars
      1. PTAnswer
    2. PO
      singulars
      1. PTAnswer
    3. PO
      singulars
      1. PTAnswer
    1. VO
      singulars
      1. POSQL query for "concatenate on join"
      1. USlathomas64
      1. VTFavorite
    2. VO
      singulars
      1. POSQL query for "concatenate on join"
      1. This table or related slice is empty.
      1. VTUpMod
    3. VO
      singulars
      1. POSQL query for "concatenate on join"
      1. This table or related slice is empty.
      1. VTUpMod
    1. COHmm sounds like you want a string aggregation function. I am not sure which databases that do that natively, but I see somtimes see user-defined functions for that (natuarlly that varies from one dmbs to another). What database are you using?
      singulars
      1. POSQL query for "concatenate on join"
      1. USFrustratedWithFormsDesigner
    2. COI'm using syabse.
      singulars
      1. POSQL query for "concatenate on join"
      1. USjrharshath
    3. COWhat errors did `list()` give? Not that I can help with Sybase problems, but someone else who can might recognize the error message.
      singulars
      1. POSQL query for "concatenate on join"
      1. USFrustratedWithFormsDesigner
 

Querying!

 
Guidance
A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload