I'm starting another project and I'm currently designing our schema. I've got a couple many-to-many joins. I was wondering if a nested table is a better solution than simply creating an intersection ...

How? I've tried every variation that I can think of and it will never let me complete a nested query...<BR><BR>Example:<BR><BR>q = "(SELECT TOP 5 * FROM data WHERE ID > " & largeID & " ORDER BY ...

Over the past few years, there has been a subtle but significant shift in the way that data is structured in databases. Whereas yesterday’s databases were typically limited to storing data in rows and ...