SQL to Get Project and Program Name

Discussion created by juan.segovia on May 8, 2013
Latest reply on May 9, 2013 by juan.segovia
Hi, i'm currently working on a grid portlet, on this portlet I need to get all my projects and several indicators from them.

One of them is the Program name, basically I need to get in one column all my projects names and in the other in case they belong to an specific program the name of that program.

Do you know how can I get that information?

I was trying to query the inv_hierarchies table but it seems I'm not getting it right.

Can you suggest any SQL query in order to get just those two fields? Project and Program Name.

Thanks in advance,