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 |
|
anbaz
Starting Member
3 Posts |
 Posted - 2009-12-23 : 09:00:59
|
| Hi All, I am new to the SQL Server.i want to write a nested SQL query for the followings:I have a table ObjectType SetUser create Edit Delete purge view Transfer SetPrivacy Invite DelMember Import Privacy---------------------------------------------------------------------------------------------------------------Workgroup NULL 3 64 64 15 1 64 64 32 64 NULL 1Workgroup NULL 3 3 3 15 1 64 64 32 64 NULL 0---------------------------------------------------------------------------------------------------------------i want to select sub table of the above with only the value = '64' Any one can help me to come out the nested SQL.Thanks & Regards,Anbaz |
|
|
vijayisonly
Master Smack Fu Yak Hacker
1836 Posts |
Posted - 2009-12-23 : 09:13:03
|
| You're question seems a li'l confusing...what is your expected output for this data? |
 |
|
|
anbaz
Starting Member
3 Posts |
Posted - 2009-12-23 : 22:44:31
|
| Hi VijayisOnly, i want to select the columns which have the value of "64" other than the '64' i don't want to select |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
anbaz
Starting Member
3 Posts |
Posted - 2009-12-24 : 01:23:54
|
| Hi, I don't have any column like '64' but i have the value of "64" in some of the columns. my target is, i need to select only the record value = 64 which ever the columns have the '64'i want a complete select statment to select which ever the column in table have the record value of "64" |
|
|
|
vijayisonly
Master Smack Fu Yak Hacker
1836 Posts |
Posted - 2009-12-24 : 11:16:21
|
As per your current table design...you will have to doSELECT * FROM yourtableWhere create = '64' or Edit = '64' or delete = '64' and so on |
|
|
|
|
|
|
Nested SQL statements request