A.F.P 3

(Difference between revisions)

Current revision as of 19:18, 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

Revision as of 19:10, 19 October 2006 (view source) Admin (Talk \| contribs) ← Previous diff		Current revision as of 19:18, 19 October 2006 (view source) Admin (Talk \| contribs)
Line 26:		Line 26:
	next page [[A.F.P 4]]		next page [[A.F.P 4]]

-	back [[A.F.P 3]]	+	back [[A.F.P 2]]