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 |
|
sureshprpt
Starting Member
33 Posts |
 Posted - 2010-07-13 : 08:36:30
|
| Dear all I want to take the report by the comibation below table. The reoprt format is COde , GL , QTY, Value. Here the issue if GL is < MM5 , the cost type 2 & > MM5 Cost type is 7.If want report with respective cost type. KIndly help me to create the qureis for my requested format report. Table 1 Code GL QtyZZ MM1 1AA MM2 4BB MM3 3CC MM4 6DD MM5 5EE MM6 4FF MM7 2GG RM 1HH RM 2Table 2 Code Cost Type CostZZ 2 10ZZ 7 20AA 2 12AA 7 14BB 2 15BB 7 26CC 2 18DD 7 24DD 2 26EE 7 30EE 2 10FF 7 28FF 2 18GG 7 10GG 2 25HH 7 10Thanks in advanceThanks & RegardsSuresh |
|
|
|
|
|
Condition to Join two table