Andrew21210
ADSM.ORG Member
- Joined
- Apr 10, 2008
- Messages
- 97
- Reaction score
- 2
- Points
- 0
Hello. I have the following select statement:
SELECT cast((n.node_name) as char(50)) as NODE , cast((n.platform_name) as char(20)) as PLATFORM , cast((n.contact) as char(50)) as CONTACT, cast((TRIM(CHAR(client_version))||'.'||TRIM(CHAR(client_release))||'.'||TRIM(CHAR(client_level))||'-'||TRIM(CHAR(client_sublevel))) as char(13)) as TSM_VERSION, cast(float(a.total_mb)/1024/1024 as DEC(8,2)) AS TOTAL_GB FROM nodes n, auditocc a WHERE n.node_name=a.node_name and n.contact like '%CIIDS%' ORDER BY 2 ASC
It works fine but I would also like to have it display the schedule_name which will need to be pulled from another table using a join. I have tried a few different things but I am not very good with joins. Could anyone assist me?
SELECT cast((n.node_name) as char(50)) as NODE , cast((n.platform_name) as char(20)) as PLATFORM , cast((n.contact) as char(50)) as CONTACT, cast((TRIM(CHAR(client_version))||'.'||TRIM(CHAR(client_release))||'.'||TRIM(CHAR(client_level))||'-'||TRIM(CHAR(client_sublevel))) as char(13)) as TSM_VERSION, cast(float(a.total_mb)/1024/1024 as DEC(8,2)) AS TOTAL_GB FROM nodes n, auditocc a WHERE n.node_name=a.node_name and n.contact like '%CIIDS%' ORDER BY 2 ASC
It works fine but I would also like to have it display the schedule_name which will need to be pulled from another table using a join. I have tried a few different things but I am not very good with joins. Could anyone assist me?