Use AdventureWorks 2014 from Microsoft Karen Berge a Documen

Use AdventureWorks 2014 from Microsoft

Karen Berge, a Document Control Assistant at the company, comes to you with a request. Karen wants the titles and file names of all of the documents she has produced and has asked you to generate this information for her. Using what you have learned, produce a query in one statement to give her the information she needs. Note that constructing the query will require some thinking outside the box since the relationships are not well documented.

Solution

// question require the details of the table without knowing nothing about table no one can answer this.

//Assuming the name of table is table_name and having columns title, file_name

SELECT title, file_name FROM table_name;