Discuss Sql Query any help would be appreciated please! in the MS SQL Development forum on Dev Shed. Sql Query any help would be appreciated please! MS SQL Development forum discussing administration, MS SQL queries, and other MS SQL-related topics. SQL Server is Microsoft's enterprise database engine.
Time spent in forums: 1 h 15 m 53 sec
Reputation Power: 0
Sql Query any help would be appreciated please!
IVe got two tables
comments is like
id userid branchid comments datetime
1 3 4 blah 2012/01/03 00:00:00
i need all branch id's and branch names from the branch table where the datetime in the comments table is a certain date like yesterday the problem is if there is no comment for a certain day it must still display the sales as null and any other comments that might have been writen for that day eg: