PJ wrote:
Gentlemen, First, let me thank you all for responding and offering suggestions. I appreciate it and I am learning things. However, it looks like my message is not getting across: The problem is not to retrieve only the authors whose last names begin with A: 1) which books have a second author? 2) who is the second author ? This is determined by table book_author column ordinal (which can be 1 or 2) - if there is only 1 author for a book then there is no ordinal 2 linked to book_author bookID and authID.
You've been given a few solutions for this and your only reply has been "doesn't do what I want".
Did you try Jim's suggestion? What didn't it do that you wanted it to? -- Postgresql & php tutorials http://www.designmagick.com/ -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
