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 |
|
anchoredwisdom
Starting Member
22 Posts |
 Posted - 2009-08-27 : 10:13:19
|
| Can anyone help me out?The output I require is thisSelect X/Y , Product X= below (X,Y is from same table)select Count(*) as X from table1---------where -----conditions-------------Y = BelowSelect count(*) as Y from table1 ----------where -------- conditions-------------------Select Product ----------------------select column 1 ( present in table1 as well as this table), column2 ( present in table2 as well as this table )from table n |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2009-08-27 : 10:20:51
|
| sorry you need to be more specific. do you want count grouped by two columns (col1 & 2), or do you want total count? |
 |
|
|
|
|
|
problem with derived tables