Sep 1, 2005 #1 JazzMaan Programmer Joined Jun 15, 2004 Messages 57 Location US i have data as: select count(ny), count(dc), count(sd) from table 35, 23, 22 i wish to have it as: 25, 23, 22. Can some one help me.
i have data as: select count(ny), count(dc), count(sd) from table 35, 23, 22 i wish to have it as: 25, 23, 22. Can some one help me.
Sep 1, 2005 1 #2 DotNetGnat Programmer Joined Mar 10, 2005 Messages 5,548 Location IN Select count(ny) from table UNION ALL Select count(dc) from table UNION ALL Select count(sd) from table -DNG Upvote 0 Downvote
Select count(ny) from table UNION ALL Select count(dc) from table UNION ALL Select count(sd) from table -DNG
Sep 1, 2005 Thread starter #3 JazzMaan Programmer Joined Jun 15, 2004 Messages 57 Location US you are the man ....!!! Upvote 0 Downvote
Sep 1, 2005 #4 DotNetGnat Programmer Joined Mar 10, 2005 Messages 5,548 Location IN thanks...glad to be of help... -DNG Upvote 0 Downvote