View Single Post
  #2 (permalink)  
Old October 21st, 2004, 06:15 PM
happygv happygv is offline
Friend of Wrox
Join Date: Jun 2003
Location: Bangalore, KA, India.
Posts: 2,480
Thanks: 0
Thanked 1 Time in 1 Post

Hi Dave,

It should be like this.
FROM A, B, C, D 
WHERE A.PrimaryKey = B.ForiegnKey and A.PrimaryKey = C.ForiegnKey and 
    A.PrimaryKey = D.ForiegnKey and TABLE_THAT_HAS_DATEFIELD.DATEFIELDNAME = getdate()
    Not sure about your table structure, so you can specify the TableName.ColumnNames separated by COMMA, in place of * in the select statement. May be you got to make changes in the query to get that work the way you wanted.

Hope that helps.

- Vijay G
Strive for Perfection