bklaas;151712 Wrote: 
> ah yes, quite right...my current slimserver appears to not be using my
> standalone mysql. This "slimserver" database I've got in my running
> mysql server may be outdated.
> 
> #!/ben

This seems to work in SQLYog

select  contributors.name ,  albums.title   from contributors , albums
, contributor_album where contributors.id=contributor_album.contributor
and albums.id=contributor_album.album order by contributors.name,
albums.title

but:
- it repeats albums where there are multiple contributors
- I still need a nice pretty print out

N


-- 
NigelC
------------------------------------------------------------------------
NigelC's Profile: http://forums.slimdevices.com/member.php?userid=2101
View this thread: http://forums.slimdevices.com/showthread.php?t=29282

_______________________________________________
discuss mailing list
[email protected]
http://lists.slimdevices.com/lists/listinfo/discuss

Reply via email to