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 |
|
rajadadi
Starting Member
30 Posts |
 Posted - 2010-04-28 : 11:50:51
|
| please write this using joins.select CI.Name, CI.CI_Status, Asso.Association_Type01, Asso.Dependency, Asso.Topology, Asso.Installed, Asso.Allocated, Asso.Language, Asso.Request_Description01 as Software Name, Asso.Submit_Date as Associationdate, CI2.Name as Software CI Name,CI2.System_Roles as Software CI Class, CI2.Product_Nodel_Version as Product_Versionfrom AST_Configuration_Item__CI_ Item where Asso.Association_Type01 = 'License to' and not(Software_name is NULL) and Company = 'Canada Post Corporation'table namesAST_Configuration_Item__CI_ CIAST_CI_Component_Associations AssoAST_Configuration_Item__CI_ CI2rajesh |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2010-04-28 : 11:54:31
|
| how are they related?------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
 |
|
|
chethana
Starting Member
6 Posts |
Posted - 2010-04-29 : 03:41:41
|
| plz post the table Structure |
|
|
|
webfred
Master Smack Fu Yak Hacker
8781 Posts |
|
|
|
|
|
|
|
pls write query using joins