INNER JOIN dbo.v_GS_NETWORK_ADAPTER_CONFIGUR NETW ON SYS.ResourceID = NETW.ResourceID INNER JOIN dbo.v_GS_WORKSTATION_STATUS WS ON WS.ResourceID = SYS.ResourceID INNER JOIN dbo.v_R_System SYS ON IPSUB.ResourceID = SYS.ResourceID TOP 100 PERCENT SYS.Name0, IP.IP_Addresses0, NET.MACAddress0,WS.LastHWScan,NET.Description0 Try something like this as your SQL Query:
