issue in DI fields multiple upload

(4 posts) (2 voices)


No tags yet.

  1. vittorio, Member

    Dear Sirs,

    We have an issue on the code prepared by your support personnel.

    We need to show two fields in our reporting , both of them are related to the same tab, same column called lang_value

    But with different FIELD_ID

    if (pfl.field_id = 4, pfl.lang_value as 'Skill',''),

    if (pfl.field_id = 11, pfl.lang_value as 'Category',''),

    What I ‘d like to understand is how I can and using what kind of command to code this option understandable by MYDBR

    Find enclosed the code of this report that need to be cnaged using , not sure IF; THEN ELSE or CASE command.
    Please support me on this.


  2. myDBR Team, Key Master

    Best place for generic MySQL questions is MySQL discussion forums.

    if you need same column from a table with different join you need to make another join with that table using another table alias.

    myDBR Team

  3. vittorio, Member

    can yuo quickly post a example code?

    please advise


  4. vittorio, Member

    can you advise me please.

    this issue is strictly replated to the way mydbr shows same fields in multiple column because different ID Reference.

    pls advise

    mysql does not give this detail.



You must log in to post.