On Mon, Dec 10, 2012 at 10:06 AM, Peter Rabbitson rabbit+d...@rabbit.uswrote:
On Fri, Dec 07, 2012 at 04:53:06PM +0100, Ekki Plicht (DF4OR) wrote:
[...]
What I want to have is the 'group number' from the link table as well.
Is there a way to get this in one go (one query)?
[...]
Hi,
I had a similar problem where the logical solution was to put an
additional attribute to the linking table. But I have not found a solution
besides fetching the data seperatly.
I am also interested how others solved this kind of problem.
Joerg
On Fri, 7 Dec 2012 16:53:06 +0100, Ekki Plicht
On Fri, Dec 07, 2012 at 04:53:06PM +0100, Ekki Plicht (DF4OR) wrote:
Hi.
Two tables with a many_to_many relation via a link table:
Table of web pages:
table webpage(id, filename, ...)
Table of images:
table images (id, filename, ...)
Table linking pages and images:
table img_grp_page