SWQL, EOC and Select commands

Since we have the EOC2.2, we  are trying to convert some custom reports that we did in MS Reporting server to SWQL. We learned a few things.

Custom properties do not appear in the nodes view when using the swql studio however that info does appear in Orion.NodesCustomProperties.

So there are two things I am stuck on. However this post will cover the first one.

select

    n.Caption,

    n.Description,

    n.Location,

    n.MachineType,

    n.Status,

    p.City,

    p.AssetTag,

    p.Device_Function,

    p.SerialNumber,

    p.Network_Zone,

    p.Number_of_Physical_Devices,

  TotalResourceUnit = 1,

   i.ObjectSubType,

   p.Resource_Unit_Name

From Orion.Nodes n

inner JOIN Orion.NodesCustomProperties p on p.NodeID = n.NodeID

inner JOIN Orion.NPM.Interfaces i on i.NodeID = n.NodeID

This query fails!

If I take:

  TotalResourceUnit = 1,

out of the query it works.

I realize SWQL is a readonly language.  I also realize  that   TotalResourceUnit = 1, is creating for a lack of a better term a column.  I need that column or the rest of the query for the report wont work.

How can I make this TotalResourceUnit = 1 work?

Thank you in advance!