Database view between Problem and Problem task

[annmol1]

Hi there,

I need to create a database view between Problem and Problem task tables. tried conditions nion where clause with prb_sys_id = ptsk_parent and prb_number = ptsk_problem; prb and ptsk being variables for Problem and Problem task tables. I get all the Problems returned, but no Problem task number against them. Can somebody help please.

Thanks in advance

Annmol

[annmol1]

hi Michael

Don't worry.. I got it working... will attach the view I created here so if it can be helpful for anyone else..

Thanks again for your great help..

Thanks

Annmol

[Rama Chandra D]

Hello Annmol,

This didn't work for me. I still don't see Problem with no tasks associated. Any help is appreciated.

Regards,

Darshak

[annmol1]

hi Darshak

I can try to help...

Please can you post a snapshot of what you have created... may be check the order and join conditions as well...

Thanks

Annmol

[Rama Chandra D]

Hi,

Allow me to apologize for this late response. I was able to get it to work. I didn't join the tables properly before   i corrected it.

Thanks,

Darshak