How to retriever info from a SQL Inner Join query with SYSTEM.MANA

28 Aug 2006 6:30 PM

ShrimpBoy

Hi!

I run this query but I'm unable to read the returned objects...

How should I handles objects returned from a SQL Query like...

"SELECT SMS_Program.CommandLine, SMS_Program.Comment,
SMS_Program.DependentProgram, SMS_Program.WorkingDirectory,
SMS_PackageStatusDistPointsSummarizer.SourceNALPath FROM SMS_Program INNER
JOIN SMS_PackageStatusDistPointsSummarizer ON
SMS_Program.PackageID=SMS_PackageStatusDistPointsSummarizer.PackageID Where
SMS_Program.ProgramName='SoftWare (Setup 6 of 6)' And
SMS_Program.PackageID='ABC00123' And
SMS_PackageStatusDistPointsSummarizer.SiteCode='ABC'"

Thanks!

ShrimpyOne

29 Aug 2006 6:19 AM

Cor Ligthert [MVP]

ShrimpBoy,

Have a look to one of these books

http://www.vb-tips.com/dbpages.aspx?ID=1b31f4f7-0596-4b8e-aaf5-e16db864a414

I hope this helps,

Cor

Show quoteHide quote

"ShrimpBoy" <Shrimp***@discussions.microsoft.com> schreef in bericht
news:01255553-1AA8-459F-B2A0-332E88A56715@microsoft.com...
> Hi!
>
> I run this query but I'm unable to read the returned objects...
>
> How should I handles objects returned from a SQL Query like...
>
> "SELECT SMS_Program.CommandLine, SMS_Program.Comment,
> SMS_Program.DependentProgram, SMS_Program.WorkingDirectory,
> SMS_PackageStatusDistPointsSummarizer.SourceNALPath FROM SMS_Program INNER
> JOIN SMS_PackageStatusDistPointsSummarizer ON
> SMS_Program.PackageID=SMS_PackageStatusDistPointsSummarizer.PackageID
> Where
> SMS_Program.ProgramName='SoftWare (Setup 6 of 6)' And
> SMS_Program.PackageID='ABC00123' And
> SMS_PackageStatusDistPointsSummarizer.SiteCode='ABC'"
>
> Thanks!
>
> ShrimpyOne