Mixing SQL TABLES with Report Writer

Question

Is it not possible to combine multiple tables into a common report using Advanced SQL with Report Writer? I need a report which shows overnight/after-hours Events by Node (reboots, down, .etc) along with any APM activity (components NOT Up) by Node. I'm trying to start the report like this but I can't get past the error: Multi-part identifier can't be bound. (I'm not knowledgeable of SQL but I'm trying to learn. Thanks for any pointers.)

SELECT 
Nodes.Caption AS NodeName,
Nodes.Status AS Status,
Nodes.StatusLED AS Status_Icon,
Events.EventTime AS Event_Time,
Events.Message AS Message,
Events_EventTypes.Name AS Event_Type_Name,
APM_AlertsAndReportsData.ApplicationName AS Application_Name,
APM_AlertsAndReportsData.ComponentName AS Component_Name,
APM_AlertsAndReportsData.ComponentStatus AS Component_Status,
APM_AlertsAndReportsData.ProcessName AS Process__Service__Name,
APM_AlertsAndReportsData.DisplayType AS Component_Type

Yann · Answer

Hi,

The FROM statement is missing from your query.

If you need to return data from mutliple tables you can use the JOIN statements.

http://en.wikipedia.org/wiki/Join_(SQL)

HTH,

Yann