Hey Ayon, That solved my probably thank you so much. The error I was getting was that the tables in the predicate were invalid.
Cheers, On Sun, Nov 20, 2011 at 12:59 AM, Ayon Sinha <[email protected]> wrote: > Have you tried using table aliases? What errors do you see? > > Sent from my iPhone > > On Nov 19, 2011, at 8:44 PM, Daniel Godfrey <[email protected]> > wrote: > > Hey everyone, > > I'm having issues trying to execute a simple join on two tables that are > in the same database namespace. I'm trying to following: > > SELECT namespace.table1.* FROM namespace.table1 JOIN namespace.table2 ON > (namespace.table1.field1 = namespace.table2.field2); > > If I move the tables outside of the database namespace, I can perform the > join just fine. > > Is it not possible to join tables within a database? Or am I missing > something? > > Cheers, > > -- > C. Daniel Godfrey > > -4th Year Software Engineering Student at the University of Ottawa > > > -- C. Daniel Godfrey -4th Year Software Engineering Student at the University of Ottawa
