A.F.P 3
From Compsci1
(Difference between revisions)
Revision as of 19:10, 19 October 2006
Using the Books and Loans tables please do the following queries
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
next page A.F.P 4
back A.F.P 3
