Community
- Command Central
- MVP Program
- Monthly Mission
- Blogs
- Groups
- Events
- Media Vault
Products
- Observability
- Network Management
- Application Management
- IT Security
- IT Service Management
- System Management
- Database Management
Content Exchange
- SolarWinds Platform
- Server & Application Monitor
- Database Performance Analyzer
- Server Configuration Monitor
- Network Performance Monitor
- Network Configuration Manager
- SQL Sentry
- Web Help Desk
Free Tools & Trials

Problem with sql code

I have wrote this SQL code but cannot find the problem with it

Select

Nodes.Caption AS ServerName,

Nodes.DeviceRole AS DeviceRole,

(

SELECT

Nodes.Caption

FROM dbo.NodeIPAddresses AS Ips

)

FROM dbo.Nodes

Find more posts tagged with

Accepted answers

Select

Nodez.Caption as Servername,

Nodez.DeviceRole as DeviceRole,

IPAddr.IPAddress as 'IP Addresses'

FROM dbo.Nodes AS Nodez

join dbo.NodeIPAddresses as IPAddr on Nodez.NodeID = IPAddr.NodeID

All comments

Well, am guessing that you just want to to list out Caption, DeviceRole and IP Address. If so, the query is a bit off. Try this:

Select

Nodes.Caption AS ServerName,

Nodes.DeviceRole AS DeviceRole,

Nodes.IP_Address AS Ips

FROM dbo.Nodes

Not sure why you were including a subselect there, for information from the same table.

Select

Nodez.Caption as Servername,

Nodez.DeviceRole as DeviceRole,

IPAddr.IPAddress as 'IP Addresses'

FROM dbo.Nodes AS Nodez

join dbo.NodeIPAddresses as IPAddr on Nodez.NodeID = IPAddr.NodeID

I Fixed it

Quick Links