11-16-2023 01:10 AM - last edited on 03-31-2024 03:45 PM by Mercedes_O
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.
11-16-2023 11:14 AM
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.
Experience Lansweeper with your own data. Sign up now for a 14-day free trial.
Try Now