Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums  General SQL Server Forums  New to SQL Server Programming  Advanced SQL Select Statement. Please Help!

Author  Topic  ppp83 Starting Member 1 Post Posted - 2009-11-03 : 09:06:52 I need some help in constructing an advanced sql select statement for report generation. This is my case: I need to produce a report for workers without wages for a period of time from certain department. My print report screen would have 2 dropdown fields - period and department. In order to identify those workers without wages, i need to search from a few tables, for example, harvesting , jobcard, transport to make sure that the worker name/id doesn't appear inside the record and the total working hour is 0 if his record exist within the selected date. This seems to involve lots of selection, where shouldi start from. First select all the active users from the vallid department, then only filter based on whether his record exist in those other tables. Please advice. Thanks in advance.