I am trying to create a database view by joining couple of tables from CDMB. While doing so I am trying to join alm_hardware table with many other cmdb tables to get corresponding information pertaining to a CI . When I make a join from alm_hardware table to any other cmdb tables the serial number filed from alm_hardware table is coming up as blank in my report. However, there are serial numbers. I am wondering why this is happening. My example Join condition is like this and I have a left outer join on the tables.
Any input would be appreciated.
