Monday 16 February 2009

HW

Display all Client name whose trainer number
is "48"or Client name is "Morgan-Alyssa

SQL
Select tblclient .ClientNum,
tblClient.Name,tblClent.[Trainer Number]
FROM tblClient
WHERE(((tblClient.[Trainer
Number])="48"))OR
(((tblClient.Name)="Morgan-Alyssa"))
ORDER BY tblClent.Name;

No comments:

Post a Comment