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

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
Back
Top