Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
scott_hanebutt
Starting Member
10 Posts |
 Posted - 2009-06-08 : 14:56:54
|
| I have two tables that contain the following fields.INMAST.FPARTNOINMAST.FPRODCLINPRSC.FSCHECODEINPRSC.FADJUST1INPRSC.FADJUST2INPRSC.FADJUST3INPRSC.FADJUST4INMAST.FPARTNO = INPRSC.FSCHECODEThe 18 and 19 FPRODCL contain many FPARTNO's that are identical to each other except that the 18 FPRODCL has '18' somewhere in the FPARTNO and the 19 PRODCL has '19' somewhere in the FPARTNO.I want to find all acurances when a 18 part has a higher value then then the 19 part in the same FADJUST field.Any help would be greatly appreciated. I realize that my database design is not very good but that is what I have to work with.Thank you,Scott |
|
|
TG
Master Smack Fu Yak Hacker
6065 Posts |
|
|
|
|
|
Select Query