Wednesday, February 18, 2009

Queries in Ashton James College Database

List all Client Names with Trainer number 48 or the client name MORGAN-ALYSSA in ascending order .

Answer:
Which clients take their training form trainer number 48?
Telton-Edwards
Center services
Fairland Lawn
Calder plastic
Hurlet National

(SELECT tblClient.ClientNum, tblClient.Name, tblClient.[Trainer Number]FROM tblClientWHERE (((tblClient.[Trainer Number])="48"))ORDER BY tblClient.Name, tblClient.[Trainer Number] DESC;)
Arrange client name in descending order.
Telton-Edwards
PRIM Staffing
Morgan-Alyssa
Hurlet Nationa
Farrow-Idsen
Fairland Lawn
Elba's Furniture
Elba's Furniture
Center Services
Calder Plastics
Blant and Sons
(SELECT tblClient.ClientNum, tblClient.Name, tblClient.[Trainer Number]FROM tblClientORDER BY tblClient.Name DESC;)

if (window['tickAboveFold']) {window['tickAboveFold'](document.getElementById("latency-7146641217945988796")); }

No comments:

Post a Comment