Re: subselect query
- From: "Kim Oppalfens [MVP]" <""Kim dot Oppalfens\"@google mail.com">
- Date: Wed, 01 Aug 2007 23:35:42 +0200
Rick wrote:
Hello,Not exactly sure, but could you try without the order by clause?
I need some assistance with a subselect query, I am trying to find all
desktops that do not have a particular app installed. Following the
instructions from this write-up http://myitforum.com/articles/1/view.asp?id=179
I am able to successfully query all desktops that have the app, here
is that query:
select SMS_G_System_SYSTEM.Name from SMS_R_System inner join
SMS_G_System_SYSTEM on SMS_G_System_SYSTEM.ResourceID =
SMS_R_System.ResourceId inner join SMS_G_System_ADD_REMOVE_PROGRAMS on
SMS_G_System_ADD_REMOVE_PROGRAMS.ResourceID = SMS_R_System.ResourceId
where SMS_G_System_ADD_REMOVE_PROGRAMS.DisplayName = "bbdo" order by
SMS_G_System_SYSTEM.Name
When I create the subselected query and browse to the first query I
created, as outlined in step 16 from the article, and click ok I
receive the error message "Please enter a valid subselect statement"
If I browse to any of the canned query's I am able to hit ok and
create the subselect query so there is definitely an issue with the
first query.
If I run the first query it runs without error, I'm not versed enough
in SQL to troubleshoot the subselect query.
Thanks for any help.
--
"Everyone is an expert at something"
Kim Oppalfens - Sms Expert for lack of any other expertise
Windows Server System MVP - SMS
http://www.blogcastrepository.com/blogs/kim_oppalfenss_systems_management_ideas/default.aspx
.
- Follow-Ups:
- Re: subselect query
- From: marc . hurley
- Re: subselect query
- References:
- subselect query
- From: Rick
- subselect query
- Prev by Date: subselect query
- Next by Date: Re: Status messages not processing
- Previous by thread: subselect query
- Next by thread: Re: subselect query
- Index(es):
Relevant Pages
|
