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.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2005-07-14 : 07:01:44
|
| Jacquie writes "I am trying to create a customer statement based on query results. I need to pull from three tables, the invoice table, the incoming pay table and the credit memo table so that I can display the amounts and dates from each. I need a parameter asking who the customer is and a date range.How can I get this information with one query?SQL Server 2000Windows 2000" |
|
|
DonAtWork
Master Smack Fu Yak Hacker
2167 Posts |
Posted - 2005-07-14 : 08:20:22
|
| Join the tables. Get only the columns you need. Use the parameters that are passed in.Now, ask your question with more information, and we can answer with more information.*need more coffee*SELECT * FROM Users WHERE CLUE > 0(0 row(s) affected) |
 |
|
|
|
|
|
Multiple Select Statements