Hello everyone! having alittle issues here...

Code:
mysql> SELECT 
    -> ncim.entity.entityId, ncim.entity.mainNodeEntityId,
    -> ncim.entity.entityName, ncim.entity.domainMgrId,
    -> ncim.entity.entityType, ncim.entity.displayLabel,
    -> ncim.entity.alias,
    -> ospfService.routerId, ospfService.entityId,
    -> ospfService.isAreaBdrRtr,ospfService.isAsBdrRtr, ospfService.isDrRtr, 
    -> ospfService.isBdrRtr, ospfService.isDrOtherRtr,
    -> ncim.hostedService.hostingEntityId, hostedService.hostedEntityId, 
    -> ncim.ospfRoutingDomain.ospfDomain, ncim.ospfRoutingDomain.entityId
    -> 
    -> FROM ospfRoutingDomain
    -> 
    -> INNER JOIN collects ON collects.collectingEntityId = ospfRoutingDomain.entityId
    -> INNER JOIN entity ON ncim.entity.entityId = collects.collectedEntityId;
ERROR 1054 (42S22): Unknown column 'ospfService.routerId' in 'field list'
mysql> describe ospfService;
+--------------+-------------+------+-----+---------+-------+
| Field | Type | Null | Key | Default | Extra |
+--------------+-------------+------+-----+---------+-------+
| entityId | int(11) | NO | PRI | | |
| routerId | varchar(15) | NO | | | |
| isAreaBdrRtr | tinyint(4) | YES | | NULL | |
| isAsBdrRtr | tinyint(4) | YES | | NULL | |
| isDrRtr | tinyint(4) | YES | | NULL | |
| isBdrRtr | tinyint(4) | YES | | NULL | |
| isDrOtherRtr | tinyint(4) | YES | | NULL | |
+--------------+-------------+------+-----+---------+-------+
7 rows in set (0.00 sec)


Anyone know why I'm getting this error? As you can see its in the table...



Im trying to mimic somthing like this (which works):
Code:
[1] SELECT s.network AS ’Network’,
[2] s.netmask AS ’Netmask’,
[3] e.entityName AS ’Entity Name’
[4] FROM subnet s
[5] INNER JOIN collects c ON c.collectingEntityId = s.entityId
[6] INNER JOIN entity e ON e.entityId = c.collectedEntityId
[7] ORDER BY s.network

ospfRoutingDomain is also a collection object so
INNER JOIN collects c ON c.collectingEntityId = s.entityId
should also work with ospfRoutingDomain rather than s.entityId 9subnet).

Any help would be great!