04-24-2015 12:08 PM
Solved! Go to Solution.
04-27-2015 01:41 PM
Select Top 1000 tblFloppy.floppyID,
tblAssets.AssetID,
tblAssets.AssetName,
tblFloppy.Name As [HDD name],
tblFloppy.Manufacturer,
tblFloppy.Model,
tblFloppy.SerialNumber,
tblFloppy.FirmwareRevision,
tblFloppy.InterfaceType,
tblFloppy.bytespersector,
tblFloppy.Partitions,
tblFloppy.Sectorspertrack,
tblFloppy.Size,
tblFloppy.Totalcylinders,
tblFloppy.Totalheads,
tblFloppy.Totalsectors,
tblFloppy.Totaltracks,
tblFloppy.TracksperCylinder,
tblFloppy.Lastchanged,
tblFloppy.Status
From tblAssets
Inner Join tblFloppy On tblAssets.AssetID = tblFloppy.AssetID
Order By tblAssets.AssetName,
[HDD name]
04-27-2015 01:47 PM
04-27-2015 01:41 PM
Select Top 1000 tblFloppy.floppyID,
tblAssets.AssetID,
tblAssets.AssetName,
tblFloppy.Name As [HDD name],
tblFloppy.Manufacturer,
tblFloppy.Model,
tblFloppy.SerialNumber,
tblFloppy.FirmwareRevision,
tblFloppy.InterfaceType,
tblFloppy.bytespersector,
tblFloppy.Partitions,
tblFloppy.Sectorspertrack,
tblFloppy.Size,
tblFloppy.Totalcylinders,
tblFloppy.Totalheads,
tblFloppy.Totalsectors,
tblFloppy.Totaltracks,
tblFloppy.TracksperCylinder,
tblFloppy.Lastchanged,
tblFloppy.Status
From tblAssets
Inner Join tblFloppy On tblAssets.AssetID = tblFloppy.AssetID
Order By tblAssets.AssetName,
[HDD name]
04-24-2015 07:54 PM