Re: [sqlalchemy] I wish to know how I use table ALIAS in alchemy core

2016-03-03 Thread Simon King
On Thu, Mar 3, 2016 at 12:01 PM, Krishnakant wrote: > > > On Thursday 25 February 2016 03:50 PM, Simon King wrote: > > On Thu, Feb 25, 2016 at 9:43 AM, Krishnakant > wrote: > >> Hello, >> I have a query where there are 2 alias for a single table.

Re: [sqlalchemy] I wish to know how I use table ALIAS in alchemy core

2016-03-03 Thread Krishnakant
On Thursday 25 February 2016 03:50 PM, Simon King wrote: On Thu, Feb 25, 2016 at 9:43 AM, Krishnakant > wrote: Hello, I have a query where there are 2 alias for a single table. This is because the table contains a self

Re: [sqlalchemy] I wish to know how I use table ALIAS in alchemy core

2016-02-25 Thread Simon King
On Thu, Feb 25, 2016 at 9:43 AM, Krishnakant wrote: > Hello, > I have a query where there are 2 alias for a single table. > This is because the table contains a self referencing foreign key. > the table is (groupcode integer primary key, groupname text, subgroupof >

[sqlalchemy] I wish to know how I use table ALIAS in alchemy core

2016-02-25 Thread Krishnakant
Hello, I have a query where there are 2 alias for a single table. This is because the table contains a self referencing foreign key. the table is (groupcode integer primary key, groupname text, subgroupof integer foreign key references groupcode). Now let's say I wish to have a 2 column query