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 relationship.
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,
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
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, pm.MethodID,
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 first