"Stefan" wrote:

> I want to put the results from two queries together in on new query. I think
> I'v to use a join but I'm not sure how.
>
> These are the two queries I want to put together:
> Query 1:
> Select Value, DiscoveryComputerID from Attribute WHERE ClassAttributeID IN
> (Select ClassAttributeID from ClassAttribute where ClassAttributeName =
> 'Action Account Identity')
>
> Result:
> DISCOVERYCOMPUTERID                    VALUE
> 07BB8BAE-35B6-4365-AB3F-2705CC8B4B11    SYSTEM
> 12453087-9282-449D-B625-892E5795F09A    SYSTEM
> 24FB0AE6-96BC-4657-8922-EA2B418C555A    SYSTEM
> 3CF4060B-40F9-41BE-9456-479A30EDBEC8    SYSTEM
> 3F13670A-E814-463E-A9CC-445BFED0FEDE    SYSTEM
> 4066CAD4-03AA-4C58-AE46-27828EFD85E8    domain\SRV-MOMAA
> 5C6C60DB-E40B-415D-B8E3-FE6946DCAA70    SYSTEM
> B38939E4-9562-40ED-ABF0-A732DB5DE2DC    SYSTEM
> CDAFE266-708C-4431-BC56-2310E4B36782    SYSTEM
> D82FD6D7-7F0D-49F5-9CDF-32FBBB83CC75    SYSTEM
> E3018CBF-C942-4474-8ED9-76A14602740D    SYSTEM
> F6137993-CA48-4AEC-B6F9-A3FDD0BB18F6    SYSTEM
> AC3368B9-851E-43EB-8621-99E23247545C    MOMDEMO\MOMAA
>
> Query 2:
> Select Name, IDComputer FROM Computer WHERE IDComputer IN
> (Select DiscoveryComputerID from Attribute WHERE ClassAttributeID IN
> (Select ClassAttributeID from ClassAttribute where ClassAttributeName =
> 'Action Account Identity'))
>
> Result:
> NAME    IDCOMPUTER
> DC01    07BB8BAE-35B6-4365-AB3F-2705CC8B4B11
> EXTEMP    12453087-9282-449D-B625-892E5795F09A
> FSCN02    24FB0AE6-96BC-4657-8922-EA2B418C555A
> SQL01    3CF4060B-40F9-41BE-9456-479A30EDBEC8
> EXCN01    3F13670A-E814-463E-A9CC-445BFED0FEDE
> MOM01    4066CAD4-03AA-4C58-AE46-27828EFD85E8
> DC02    5C6C60DB-E40B-415D-B8E3-FE6946DCAA70
> EXCN02    B38939E4-9562-40ED-ABF0-A732DB5DE2DC
> PSCN01    CDAFE266-708C-4431-BC56-2310E4B36782
> PSCN02    D82FD6D7-7F0D-49F5-9CDF-32FBBB83CC75
> SMS01    E3018CBF-C942-4474-8ED9-76A14602740D
> FSCN01    F6137993-CA48-4AEC-B6F9-A3FDD0BB18F6
>
> And now I want to put those results together with a join between
> DISCOVERYCOMPUTERID and IDCOMPUTER.
>
> How do I do that?
>
> Regards,
> Stefan Stranger
>
>
>

"Paul" wrote:

> Hi,
>
> I think this should do it...
>
> Select Value, DiscoveryComputerID, Name, IDComputer
> from Attribute INNER JOIN Computer ON DISCOVERYCOMPUTERID = IDCOMPUTER
> WHERE ClassAttributeID IN (Select ClassAttributeID from ClassAttribute where
> ClassAttributeName = 'Action Account Identity')
> AND IDComputer IN (Select DiscoveryComputerID from Attribute WHERE
> ClassAttributeID IN (Select ClassAttributeID from ClassAttribute where
> ClassAttributeName = 'Action Account Identity'))
>
>
> Ta
> Paul
>
> "Stefan" wrote:
>
> > I want to put the results from two queries together in on new query. I think
> > I'v to use a join but I'm not sure how.
> >
> > These are the two queries I want to put together:
> > Query 1:
> > Select Value, DiscoveryComputerID from Attribute WHERE ClassAttributeID IN
> > (Select ClassAttributeID from ClassAttribute where ClassAttributeName =
> > 'Action Account Identity')
> >
> > Result:
> > DISCOVERYCOMPUTERID                    VALUE
> > 07BB8BAE-35B6-4365-AB3F-2705CC8B4B11    SYSTEM
> > 12453087-9282-449D-B625-892E5795F09A    SYSTEM
> > 24FB0AE6-96BC-4657-8922-EA2B418C555A    SYSTEM
> > 3CF4060B-40F9-41BE-9456-479A30EDBEC8    SYSTEM
> > 3F13670A-E814-463E-A9CC-445BFED0FEDE    SYSTEM
> > 4066CAD4-03AA-4C58-AE46-27828EFD85E8    domain\SRV-MOMAA
> > 5C6C60DB-E40B-415D-B8E3-FE6946DCAA70    SYSTEM
> > B38939E4-9562-40ED-ABF0-A732DB5DE2DC    SYSTEM
> > CDAFE266-708C-4431-BC56-2310E4B36782    SYSTEM
> > D82FD6D7-7F0D-49F5-9CDF-32FBBB83CC75    SYSTEM
> > E3018CBF-C942-4474-8ED9-76A14602740D    SYSTEM
> > F6137993-CA48-4AEC-B6F9-A3FDD0BB18F6    SYSTEM
> > AC3368B9-851E-43EB-8621-99E23247545C    MOMDEMO\MOMAA
> >
> > Query 2:
> > Select Name, IDComputer FROM Computer WHERE IDComputer IN
> > (Select DiscoveryComputerID from Attribute WHERE ClassAttributeID IN
> > (Select ClassAttributeID from ClassAttribute where ClassAttributeName =
> > 'Action Account Identity'))
> >
> > Result:
> > NAME    IDCOMPUTER
> > DC01    07BB8BAE-35B6-4365-AB3F-2705CC8B4B11
> > EXTEMP    12453087-9282-449D-B625-892E5795F09A
> > FSCN02    24FB0AE6-96BC-4657-8922-EA2B418C555A
> > SQL01    3CF4060B-40F9-41BE-9456-479A30EDBEC8
> > EXCN01    3F13670A-E814-463E-A9CC-445BFED0FEDE
> > MOM01    4066CAD4-03AA-4C58-AE46-27828EFD85E8
> > DC02    5C6C60DB-E40B-415D-B8E3-FE6946DCAA70
> > EXCN02    B38939E4-9562-40ED-ABF0-A732DB5DE2DC
> > PSCN01    CDAFE266-708C-4431-BC56-2310E4B36782
> > PSCN02    D82FD6D7-7F0D-49F5-9CDF-32FBBB83CC75
> > SMS01    E3018CBF-C942-4474-8ED9-76A14602740D
> > FSCN01    F6137993-CA48-4AEC-B6F9-A3FDD0BB18F6
> >
> > And now I want to put those results together with a join between
> > DISCOVERYCOMPUTERID and IDCOMPUTER.
> >
> > How do I do that?
> >
> > Regards,
> > Stefan Stranger
> >
> >
> >

> I want to put the results from two queries together in on new query. I
> think I'v to use a join but I'm not sure how.
>
> These are the two queries I want to put together:
> Query 1:
> Select Value, DiscoveryComputerID from Attribute WHERE
> ClassAttributeID IN
> (Select ClassAttributeID from ClassAttribute where ClassAttributeName
> =
> 'Action Account Identity')
> Result:
> DISCOVERYCOMPUTERID                    VALUE
> 07BB8BAE-35B6-4365-AB3F-2705CC8B4B11    SYSTEM
> 12453087-9282-449D-B625-892E5795F09A    SYSTEM
> 24FB0AE6-96BC-4657-8922-EA2B418C555A    SYSTEM
> 3CF4060B-40F9-41BE-9456-479A30EDBEC8    SYSTEM
> 3F13670A-E814-463E-A9CC-445BFED0FEDE    SYSTEM
> 4066CAD4-03AA-4C58-AE46-27828EFD85E8    domain\SRV-MOMAA
> 5C6C60DB-E40B-415D-B8E3-FE6946DCAA70    SYSTEM
> B38939E4-9562-40ED-ABF0-A732DB5DE2DC    SYSTEM
> CDAFE266-708C-4431-BC56-2310E4B36782    SYSTEM
> D82FD6D7-7F0D-49F5-9CDF-32FBBB83CC75    SYSTEM
> E3018CBF-C942-4474-8ED9-76A14602740D    SYSTEM
> F6137993-CA48-4AEC-B6F9-A3FDD0BB18F6    SYSTEM
> AC3368B9-851E-43EB-8621-99E23247545C    MOMDEMO\MOMAA
> Query 2:
> Select Name, IDComputer FROM Computer WHERE IDComputer IN
> (Select DiscoveryComputerID from Attribute WHERE ClassAttributeID IN
> (Select ClassAttributeID from ClassAttribute where ClassAttributeName
> =
> 'Action Account Identity'))
> Result:
> NAME    IDCOMPUTER
> DC01    07BB8BAE-35B6-4365-AB3F-2705CC8B4B11
> EXTEMP    12453087-9282-449D-B625-892E5795F09A
> FSCN02    24FB0AE6-96BC-4657-8922-EA2B418C555A
> SQL01    3CF4060B-40F9-41BE-9456-479A30EDBEC8
> EXCN01    3F13670A-E814-463E-A9CC-445BFED0FEDE
> MOM01    4066CAD4-03AA-4C58-AE46-27828EFD85E8
> DC02    5C6C60DB-E40B-415D-B8E3-FE6946DCAA70
> EXCN02    B38939E4-9562-40ED-ABF0-A732DB5DE2DC
> PSCN01    CDAFE266-708C-4431-BC56-2310E4B36782
> PSCN02    D82FD6D7-7F0D-49F5-9CDF-32FBBB83CC75
> SMS01    E3018CBF-C942-4474-8ED9-76A14602740D
> FSCN01    F6137993-CA48-4AEC-B6F9-A3FDD0BB18F6
> And now I want to put those results together with a join between
> DISCOVERYCOMPUTERID and IDCOMPUTER.
>
> How do I do that?
>
> Regards,
> Stefan Stranger