MatrixAttributeDisplayOrder help

UK Discussion in 'Microsoft Point Of Sale' started by Ilya, May 14, 2013.

  1. Ilya


    May 14, 2013
    Likes Received:
    Hello, I've been struggling for a few weeks now trying to figure out how the colour code in MatrixAttributeDisplayOrder corresponds to the Item table.

    I need to pull the corresponding colour code using either item id or item lookup code. I tried to join the tables on id columns but it didn't return anything and then using the alias table inbetween which returns some results but they don't look right

    Here is my query using the alias table as glue between item and the matrix table

    ISNULL((SELECT TOP 1 Code FROM MatrixAttributeDisplayOrder WHERE MatrixAttributeDisplayOrder.ID = (SELECT TOP 1 ID FROM Alias WHERE Alias.ItemID = Item.ID)),'')

    Please help =)
    Ilya, May 14, 2013
    1. Advertisements

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments (here). After that, you can post your question and our members will help you out.
Similar Threads
There are no similar threads yet.