Books database query

[Crow T. Robot]

I have a simple program in which basically I must use the books database. Well, it would be simple except I don't know how to start it, and have virtually no SQL code to reference. Damn textbook doesn't give any.

The program must simply select all authors from the authors table, select all publishers from the publishers table, select a specific author and list all books for that author, including title, year, and ISB. The information should be alphabetically ordered by last name then first name. Select a specific publisher and list all books published by them, including title, year, and ISBN. Organize it alphabetically. This must all be done through predefined queries I make. And it must be displayed in a JComboBox. I know most of the GUI, though.

This is my focus now, but I'd appreciate it if I could get help on how to provide at least 3 queries.

[sde]

i've read and re-read this, and i can't make sense of it. can you break up that paragraph a bit? do you need all that info in 1 query?

[Belisarius]

Well, as for the first one, that's pretty trivial. Here's how I'd do it in PostgreSQL:

SELECT publisher FROM publisher_table ORDER BY publisher ASC;

Rename the column and table to taste.

Try slapping together the other two and post them if you think you need more help.

[Crow T. Robot]

Originally Posted by Belisarius

Well, as for the first one, that's pretty trivial. Here's how I'd do it in PostgreSQL:

SELECT publisher FROM publisher_table ORDER BY publisher ASC;

Rename the column and table to taste.

Try slapping together the other two and post them if you think you need more help.

Nevermind. I already got all that set up (it doesn't have to be a real program, just the SQL pieces of code in a word document). Just check out my question in the Java forum.