ManyToMany Intermediate Table on a Separate Database?

2011-03-26 Thread Mazery Smith
Hey, I tried setting up an intermediate manytomany table relationship where my intermediate table is in one database, my user table (target table) is in a registration database and my data table (source table) is in another database. Things aren't working correctly and I'm just checking to make su

Re: ManyToMany Intermediate Table on a Separate Database?

2011-03-26 Thread Daniel Roseman
On Saturday, March 26, 2011 7:33:23 PM UTC, Mazery Smith wrote: > > Hey, > I tried setting up an intermediate manytomany table relationship where > my intermediate table > is in one database, my user table (target table) is in a registration > database and my data table (source table) is in ano

Re: ManyToMany Intermediate Table on a Separate Database?

2011-03-26 Thread Mazery Smith
Thanks Daniel Roseman...you're always saving me ;) On Mar 26, 12:47 pm, Daniel Roseman wrote: > On Saturday, March 26, 2011 7:33:23 PM UTC, Mazery Smith wrote: > > > Hey, > > I tried setting up an intermediate manytomany table relationship where > > my intermediate table > > is in one database, m

Re: ManyToMany Intermediate Table on a Separate Database?

2011-03-29 Thread Tomasz Zieliński
(Sorry Daniel, I replied to your private email by accident - the new Google Groups UI misled me.) Actually in MySQL you can easily work around that limitation - you can use database VIEWs as mirrors of tables placed in other databases. -- Tomasz Zielinski pyconsultant.eu -- You received this