Re: [GENERAL] FROM + JOIN when more than one table in FROM

2008-03-13 Thread Sam Mason
On Wed, Mar 12, 2008 at 12:48:22PM +0100, Ivan Sergio Borgonovo wrote: > On Wed, 12 Mar 2008 11:48:24 +0100 Martijn van Oosterhout <[EMAIL PROTECTED]> > wrote: > > Perhaps this would owrk: > > > FROM sm inner join st inner join pt inner join pm > > one of the inner join doesn't have an on relati

Re: [GENERAL] FROM + JOIN when more than one table in FROM

2008-03-12 Thread Scott Marlowe
On Wed, Mar 12, 2008 at 4:48 AM, Ivan Sergio Borgonovo <[EMAIL PROTECTED]> wrote: > one of the inner join doesn't have an on relationship. > > As you could see in the other (longer) query I'm just trying to put in > the same row what would be Could you get what you want by cross joining the fi

Re: [GENERAL] FROM + JOIN when more than one table in FROM

2008-03-12 Thread Ivan Sergio Borgonovo
On Wed, 12 Mar 2008 11:48:24 +0100 Martijn van Oosterhout <[EMAIL PROTECTED]> wrote: > On Wed, Mar 12, 2008 at 11:40:18AM +0100, Ivan Sergio Borgonovo > wrote: > > I'd like to make this query work > > > > select 1, > > st.Name, sm.Name, sm.MethodID, sm.Description, > > pt.Name, pm.Name, p

Re: [GENERAL] FROM + JOIN when more than one table in FROM

2008-03-12 Thread Martijn van Oosterhout
On Wed, Mar 12, 2008 at 11:40:18AM +0100, Ivan Sergio Borgonovo wrote: > I'd like to make this query work > > select 1, > st.Name, sm.Name, sm.MethodID, sm.Description, > pt.Name, pm.Name, pm.MethodID, pm.Description > from > shop_commerce_paymethods pm, > shop_commer

[GENERAL] FROM + JOIN when more than one table in FROM

2008-03-12 Thread Ivan Sergio Borgonovo
I'd like to make this query work select 1, st.Name, sm.Name, sm.MethodID, sm.Description, pt.Name, pm.Name, pm.MethodID, pm.Description from shop_commerce_paymethods pm, shop_commerce_shipmethods sm inner join shop_commerce_shiptypes st on s