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
Store

Help with SWQL

tmittel

Is it possible to create two columns pulling data from the Table/Rows each with their own WHERE clause?

Incorrect but shows what I am looking for:

SELECT

t1.NameA,

t1.NameB

FROM

(SELECT

a.Name as NameA,

b.Name as NameB

from Orion.Test.Name as a

LEFT JOIN

(SELECT

Name

ReferenceID

FROM Orion.Test.Name

WHERE Name = 'B' ) as b ON b.ReferenceID = a.ReferenceID

WHERE Name = 'A') as t1

When I try this format I and getting multiple duplicate values and Im sure its due to the WHERE clause. I am not too strong on SWQL and it could be a simple fix

@mesverrum

Find more posts tagged with

Accepted answers

All comments

Seashore

Can you explain more what you want to do. Not use I understand.

Here is an example that works with WHERE-clause on the two tables.

SELECT
N1.Caption,
N2.Caption
FROM Orion.Nodes N1
INNER JOIN Orion.Nodes N2 ON N1.Nodeid=N2.NodeID AND N2.Vendor='Cisco'
WHERE N1.MachineType<>'Windows'

mesverrum

^ same, the generic examples are too abstract for me to wrap my head around your use case. Post up real code and I can probably tell you what you are running into. If you want to collapse two tables with whatever conditions into a single table I'd most likely just union the two queries, no join needed. If the point is to correlate table a to table b based on something then yes each join can be a subquery with it's own where, but the secret sauce is going to be finding the correct thing to link them up on to avoid duplication.