→ 🚀What's New? Explore Lansweeper's Fall 2024 Updates! Fall Launch Blog !

cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
Jojo27
Engaged Sweeper

is this possible calling an existing report on the new report I'm doing? I'm not too familiar with SQL and just a slight knowledge of it.

example. 
existing report is all asset that has a specific Account on their system.

new report should be excluding all those assets that is already been on the existing report.

Any help is appreciated.

1 REPLY 1
ErikT
Lansweeper Tech Support
Lansweeper Tech Support

@Jojo27 

 

This can be done using subqueries.  

 

eg. 

Use the first query and slim it down to only the record ID's and use that query as a subquery to exclude these record ID's  in your final query.

 

SQL Subqueries - w3resource