[Crow T. Robot]

See the post you quoted again. I changed a lot of stuff. And it is only command line, though I think the JOptionPane will make some windows for text. Maybe not.

As for my SQL coding, I just need to know one thing. How do I choose a specific author with SELECT?

Edit: Here's the code I have for that so far.

//select all authors from authors table
{
SELECT*FROM authors
}

//select all publishers from publishers table
{
SELECT*FROM publishers
}

select author, list all books for author including title, year, and ISBN
{
SELECT copyright, title, ISBN, firstName, lastName
FROM titles
INNER JOIN authors
ON title.lastName=authors.lastName
WHERE lastName LIKE ’Nieto’
	ORDER BY lastName
}

//select a specific publisher, list all books published by them, include title, year, and ISBN
{
SELECT publisher, title, ISBN
	FROM titles
	INNER JOIN publishers
		ON publishers.publisher=titles.publisher
	WHERE publisher LIKE ‘Random House’
	ORDER BY title
}