We are extracting defect details from database. also, we want to retrieve one more column i.e linked/failed Test Case Name associated to the defect in the same report.

will it possible to retrieve this information by DB query?
or we have to use standard Linked defects report only?

I am not seeing any link between defect tables and test runs.

Could you please help.