I not following the logic here

and I can't get that to parse in QA.

Think I need another coffee.

I have a ContributorSequenceNumber column on the BookContributor table which has either and int, or a null in it. I need to have the lowest Int Number as my...

OK. Anyone know how I might go about getting BOTH authors names into a single text/varchar field and have unique book results?

govinn, thanks!

Looks like you given me the lead I needed. I had no idea you could join a subquery like that.

Hi Guys

Lets say our book table looks something like this:

BookID (int PK) Title ISBN

1 ...

Yes there can be more than one author per book, and I would very much like to isolate only one.

The Book table stores generic data about the book; Title,...