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.

   Thanks
2. 

   myDBR Team, Key Master

   Best place for generic MySQL questions is MySQL discussion forums.

   http://forums.mysql.com/

   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

   thanks
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.

   thanks

Reply

You must log in to post.