Not seeing data in Database View??

wdookie
Mega Contributor

I am currently working on a Database View, so I can do a report.   The report consists of data from 3 tables (pm_project, pm_project_task and time_card).   My database view that I am playing with consists of the following View Tables:

 

find_real_file.png

 

On the project task table I am matching the task number to the task number on the time card table.

 

On the project table I am matching the Project Number to the Project Number on the Project Task Table.

 

My Left Join criteria I have set all to true, since right now this is the only way I am getting data back.   However, the 81 data records   I am getting back looks like junk:

 

find_real_file.png

 

Fields are blank, or they say, false, UNKNOWN, (empty)...

 

I know I am doing something fundamentally wrong here.   Any guidance will be GREATLY appreciated.

 

Thanks!!!!!!

6 REPLIES 6

Yeah... sys_id worked for me too. Thanks a lot!!


Under your "Order", make sure they are also different numbers EG, 100, 200, 300. From what I have read and created, they should also be unique.