SQL Report

SQL Report

Looking for an SQL Report that would contain the following fields. CIName, Original Serial No, Manufacturer, Model, Asset Tag, Purchase Order Name, Acquisition Date, Warranty Expiry Date, Disposed Date, and Attachment Location. I need to have the report provide all disposed assets between two disposed dates. I could figure out most of the joins except the Attachment Location where there may be more than one attachment to the CI.