What version of MySQL are you using? You may be able to solve this by using a nested query. http://dev.mysql.com/doc/mysql/en/subqueries.html
Also I was confused about what you are attempting to pull from the DB. I see where you wrote '...Ie if theres more than 1 author, it lists 2 sets of data...'. Is this not the desired result? Also --- Gordon Stewart <[EMAIL PROTECTED]> wrote: > $query="SELECT * FROM Books,Master,Author,Publisher WHERE > Master.Author=\"$author\" AND (Master.ISBN=Books.ISBN) AND > (Author.ID=Master.Author) AND(Publisher.Unique=Books.Publisher)"; > > Hi, Obviously im doing a book catalogue site - & everything works ok... > > However - > > I'm wanting to list the books by 'Author' - Which it does.. > > However - several books have multiple authors.. > (listed in the 'Master' Table...) > > I guess I'll have to do 2 queries - But I'm just wondering... > > is there a way do do "(Author.ID=Master.Author)" after the rest has > been gathered ? > > Ie if theres more than 1 author, it lists 2 sets of data.... > > I guess i'll have to do 2 queries - just checking... > > -- > > G Stewart > NZ community groups - [EMAIL PROTECTED] > Community email addresses: Post message: [email protected] Subscribe: [EMAIL PROTECTED] Unsubscribe: [EMAIL PROTECTED] List owner: [EMAIL PROTECTED] Shortcut URL to this page: http://groups.yahoo.com/group/php-list Yahoo! Groups Links <*> To visit your group on the web, go to: http://groups.yahoo.com/group/php-list/ <*> To unsubscribe from this group, send an email to: [EMAIL PROTECTED] <*> Your use of Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/
