A.F.P 3

From Compsci1

Revision as of 19:10, 19 October 2006 by Admin (Talk | contribs)
(diff) ←Older revision | view current revision (diff) | Newer revision→ (diff)

Using the Books and Loans tables please do the following queries

Image:4page4a.pngImage:4page4b.png

Search the following options –

Show all books

Show all books published by collins

Show all books that begin with “the”

Show all books published before 1994

Show all books that published before 1994 and after 2000 on one table

Show the ISBN numbers for all books taken out by mem #1

Show the books for this mem

Show all books taken out for more that 10 days


Databases

next page A.F.P 4

back A.F.P 3

Retrieved from "http://editthis.info/compsci1/A.F.P_3"
Personal tools
Handy Pages