Monday 16 February 2009

Quaries of Client and Trainer

Display Client name where trainer number
is “48” of Client name is “Morgan Alyssa.

SQL
SELECT Client.[Cilent Number], Client.name, Client.[trainer number]
FROM Client
WHERE (((Client.name)="Morgan-Alyssa") AND ((Client.[trainer number])="48"))
ORDER BY Client.name;

1 comment:

  1. not very good organism
    i cant understand
    don't be lazy
    BUT some are good

    ReplyDelete