Question

Write a SELECT statement that returns these three columns: vendor_nameThe vendor_name column from the Vendors table default_accountThe default_account_number column from the Vendors table descriptionThe account_description column from the General_Ledger_Accounts table Return one row for each vendor. This should return 122 rows. Sort the result set by account_description and then by vendor_name.

Answer 1

Explanation:

"Select vendor_name as Vendor_Name,

default_account_number as Default_Account_No ,

account_description as Account_Description

From Vendors v, General_Ledger_Accounts ledger

where (add the join condition here)

Order by account_description, vendor_name"

Note: In the above statement, include the alias name appropriately and then execute the query

The "select statement" should contain the list of columns to be displayed

"From statement" should contain the name of the table from which data needs to be fetched.

"Where clause" defines the relationship as well the condition that needs to be executed

"Order by clause" defines the sorting mechanism with the relevant field