
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎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.
- Labels:
-
Built-In Reports
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎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.
