 | |
#11
 
| |||
| |||
|
Re: he;p with sql+ -
01-04-2008
, 01:46 PM
|
David, that was not the same problem this is another one, that is not working with the (+) David told me about;even though for the first one it worked; these data are real, and the way i want them to be is as the first table, i gave in the former message, while when using the formula i put, i am getting resultsas the second table where all the numbers are 497953000 or 0, and this is surely wrong. **it is not that i dont take advice well, it is only that i am in the very first steps of learning SQL, and there may be things that you here give but i dont even understand how they work, i need more work with SQL, i am not a kind of dumb that doesnt take advices, i m just without experience yet. and there are many things i dont know. Thanks again for your understanding and for your help! |
last post in that thread):
http://groups.google.com/group/comp....f960727d4854f4
I think that I see another problem with your SQL statement:
"from purinv, purch,prod,sales"
...
You are selecting rows from 4 tables...
"where purinv.Code = purch.Inv_Code and sales.prod_code = prod.code
and purch.Prod_Code in ('SP-20.2', 'SP-20.1', 'SP-20.6')"
...
You are joining:
purinv to purch
and sales to prod
You likely need at least one more join condition in the WHERE clause
to define how the set (purinv to purch) is related to the set (sales
to prod) in order to avoid a Cartesian join between the two data
sets. Cartesian join: if there are 100 rows in the first set (purinv
to purch) and 100 rows in the second set (sales to prod), you will end
up with 10,000 result rows - in your case, this would greatly increase
the value returned by SUM, especially if you were expecting only 100
rows in the result set.
Charles Hooper
IT Manager/Oracle DBA
K&M Machine-Fabricating, Inc.
#12
| |||
| |||
|
|
David, that was not the same problem this is another one, that is not working with the (+) David told me about;even though for the first one it worked; these data are real, and the way i want them to be is as the first table, i gave in the former message, while when using the formula i put, i am getting resultsas the second table where all the numbers are 497953000 or 0, and this is surely wrong. **it is not that i dont take advice well, it is only that i am in the very first steps of learning SQL, and there may be things that you here give but i dont even understand how they work, i need more work with SQL, i am not a kind of dumb that doesnt take advices, i m just without experience yet. and there are many things i dont know. Thanks again for your understanding and for your help! |
last post in that thread):
http://groups.google.com/group/comp....f960727d4854f4
I think that I see another problem with your SQL statement:
"from purinv, purch,prod,sales"
...
You are selecting rows from 4 tables...
"where purinv.Code = purch.Inv_Code and sales.prod_code = prod.code
and purch.Prod_Code in ('SP-20.2', 'SP-20.1', 'SP-20.6')"
...
You are joining:
purinv to purch
and sales to prod
You likely need at least one more join condition in the WHERE clause
to define how the set (purinv to purch) is related to the set (sales
to prod) in order to avoid a Cartesian join between the two data
sets. Cartesian join: if there are 100 rows in the first set (purinv
to purch) and 100 rows in the second set (sales to prod), you will end
up with 10,000 result rows - in your case, this would greatly increase
the value returned by SUM, especially if you were expecting only 100
rows in the result set.
Charles Hooper
IT Manager/Oracle DBA
K&M Machine-Fabricating, Inc.
#13
| |||
| |||
|
|
David, that was not the same problem this is another one, that is not working with the (+) David told me about;even though for the first one it worked; these data are real, and the way i want them to be is as the first table, i gave in the former message, while when using the formula i put, i am getting resultsas the second table where all the numbers are 497953000 or 0, and this is surely wrong. **it is not that i dont take advice well, it is only that i am in the very first steps of learning SQL, and there may be things that you here give but i dont even understand how they work, i need more work with SQL, i am not a kind of dumb that doesnt take advices, i m just without experience yet. and there are many things i dont know. Thanks again for your understanding and for your help! |
last post in that thread):
http://groups.google.com/group/comp....f960727d4854f4
I think that I see another problem with your SQL statement:
"from purinv, purch,prod,sales"
...
You are selecting rows from 4 tables...
"where purinv.Code = purch.Inv_Code and sales.prod_code = prod.code
and purch.Prod_Code in ('SP-20.2', 'SP-20.1', 'SP-20.6')"
...
You are joining:
purinv to purch
and sales to prod
You likely need at least one more join condition in the WHERE clause
to define how the set (purinv to purch) is related to the set (sales
to prod) in order to avoid a Cartesian join between the two data
sets. Cartesian join: if there are 100 rows in the first set (purinv
to purch) and 100 rows in the second set (sales to prod), you will end
up with 10,000 result rows - in your case, this would greatly increase
the value returned by SUM, especially if you were expecting only 100
rows in the result set.
Charles Hooper
IT Manager/Oracle DBA
K&M Machine-Fabricating, Inc.
 |
« Previous Thread
|
Next Thread »
| Thread Tools | |
| Display Modes | |
Linear Mode
| |
Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.