
March 25th, 2004, 09:14 AM
|
|
Registered User
|
|
Join Date: Mar 2004
Posts: 2
Time spent in forums: < 1 sec
Reputation Power: 0
|
|
Adding date and time
I am trying to add a date and time field to this query, but am really having problems with it. Would appreciate any help I can get. I am new to SQL and don't quite understand everything yet.
use Brians
DROP VIEW FanSpeeds
GO
CREATE VIEW FanSpeeds AS
SELECT NodeTable.node_id, NodeTable.label, Histories.hist_id, Histories.var_name, Data.pt_data
FROM NodeTable
INNER JOIN Histories ON NodeTable.node_id = Histories.node_id
INNER JOIN Data ON Histories.hist_id = Data.hist_id
WHERE NodeTable.node_id = '103117-549' AND Histories.hist_id BETWEEN 60 and 64
GO
SELECT * FROM FanSpeeds order by hist_id
Last edited by bfarrand : March 25th, 2004 at 10:59 AM.
|