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")); }
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment