Hello,
I have set up my database in access using many to many relationships (it's
the good ol' books and authors one again). I've actually extended it to
include other people who contribute in various ways to the books (e.g.
editors, illustrators etc), so there's more than one many to many
relationship there.
When there's an entry in all the tables relating to the book I want to view,
everything works fine (i.e. there's an author in the author table, an
illustrator in the illustrator table, an editor in the editor table) - my
join tables do their job and there's no problem.
However... when there's say no an illustrator in the illustrator table
relating to the book, I get nothing back at all from my query, no book
details or author.
When I do one to many joins usually changing the sql to use LEFT JOINs
instead of INNER JOINs does the trick, but when I try this here Access tells
me "Join Expression Not Supported".
Any help would be much appreciated. I can post the SQL if it helps.
Thanks,
Phil