select nefunkcny

MisakNo10 · Napísal **MisakNo10**: 07.06.2010 12:00 | select nefunkcny

SELECT
L2000.ITEM_CARRIER.ITEM_ID,
L2000.ITEM_RULES.RE_ORDER_QTY,
SUM(L2000.ITEM_CARRIER.PHYSIC_QTY) AS MNO
FROM
L2000.ITEM_CARRIER,
L2000.ITEM_RULES

WHERE
L2000.ITEM_RULES.RE_ORDER_QTY > MNO

neviete niekto preco mi vypisuje invalid identifier? skusal som davat MNO aj do uvodzoviek aj apostrofov a nic

don jebot · Napísal **don jebot**: 07.06.2010 12:38 | select nefunkcny

as sluzi iba na pomenovanie stlpca ak sa nemilim neviem ci ho mozes pouzit na porovnanie ..

coldak · Napísal **coldak**: 07.06.2010 13:02 | select nefunkcny

sum() bez group by ? to ktora db umoznuje ?

MisakNo10 · Napísal autor témy **MisakNo10**: 07.06.2010 13:35 | select nefunkcny

coldak píše:

sum() bez group by ? to ktora db umoznuje ?

group by uz som dorobil, mmtalne vyzera takto a stale mi pise invalid identifier

SELECT
L2000.ITEM_CARRIER.ITEM_ID,
L2000.ITEM_RULES.RE_ORDER_QUANTITY,
SUM(l2000.ITEM_CARRIER.PHYSIC_QTY) AS MNOZSTVO
FROM
L2000.ITEM_CARRIER,
L2000.ITEM_RULES

WHERE
L2000.ITEM_RULES.ITEM_ID=L2000.ITEM_CARRIER.ITEM_ID AND
L2000.ITEM_RULES.STORER_ID=L2000.ITEM_CARRIER.STORER_ID AND
L2000.ITEM_RULES.RE_ORDER_QUANTITY > MNOZSTVO

GROUP BY
L2000.ITEM_CARRIER.ITEM_ID,
L2000.ITEM_RULES.RE_ORDER_QUANTITY

coldak · Napísal **coldak**: 07.06.2010 14:04 | select nefunkcny

no a teraz vyskusaj

Kód:

SELECT 
L2000.ITEM_CARRIER.ITEM_ID, 
L2000.ITEM_RULES.RE_ORDER_QUANTITY, 
SUM(l2000.ITEM_CARRIER.PHYSIC_QTY) AS MNOZSTVO 
FROM 
  L2000.ITEM_CARRIER, 
  L2000.ITEM_RULES 
WHERE 
  L2000.ITEM_RULES.ITEM_ID=L2000.ITEM_CARRIER.ITEM_ID AND  
  L2000.ITEM_RULES.STORER_ID=L2000.ITEM_CARRIER.STORER_ID AND 
GROUP BY 
L2000.ITEM_CARRIER.ITEM_ID, 
L2000.ITEM_RULES.RE_ORDER_QUANTITY
having 
L2000.ITEM_RULES.RE_ORDER_QUANTITY > SUM(l2000.ITEM_CARRIER.PHYSIC_QTY) 

MisakNo10 · Napísal autor témy **MisakNo10**: 07.06.2010 14:08 | select nefunkcny

SUPER, DAKUJEM

select nefunkcny

select nefunkcny

Podobné témy

formular: presun <option> zo <select> do <select>

select

select

SELECT

Select

Multi select

Select porovnanie

Select option

Stromový select

zly select

select datetime

SELECT OPTION

MySQL Select

Komplikovany select

Select script

SELECT DISTINCT