|
should there be an 'and' in the 'on' clause? without your data schema it's hard to figure out what you're doing. .. i just tried to have a wack at it and i am totally lost with your table names and that join syntax.
what db are you using? and maybe tell a little bit more about the tables you are querying.
__________________
Mike
|