Query with a WHERE clause. How do I add more records to it?

Hi phk_Holship 

(1) I recommend not using the select-from-multiple-tables format using the table names with commas. This is an implicit CROSS JOIN action between the table and I highly recommend to use CROSS JOIN explicitly

Instead of `FROM database.FinancePosting, database.[File]` it's prefered in my opinion to use `FROM database.FinancePosting CROSS JOIN database.[File]`

> The query works.

(2) What do you mean the query works if it does not return the requested information?!?

It sound like the query run without error but does not work for you.

> I want to add records where FinancePosting.NomID is equal to 2400. 

(3) If you want to add more recording that does not fit the current filter then you need to use `OR` condition. This way you get all the rows which fit the first filter and all the rows which fit the second filter.

Note! It could help if you provided a table and some data to work with (queries to create the tables and insert some rows for the sample)!

In general (without testing since you did not provided the information I mentioned) it should be something like:

SELECT 
FinancePosting.Period, 
FinancePosting.NomID, 
FinancePosting.FileID, 
[File].FilenumberID 
FROM 
database.FinancePosting, database.[File] 
WHERE
(
FinancePosting.Period BETWEEN 2200 AND 2299 
AND FinancePosting.FileID = [File].FileID
)
OR FinancePosting.NomID = 2400

Note: if this does not solve your needs then please provide

1) Queries to CREATE your table(s) including indexes
2) Queries to INSERT sample data.
3) The desired result given the sample, as text or image of excel for example.
4) A short description of the business rules, and how you got 1-2 of the results
5) Which version of SQL Server you are using (this will help to fit the query to your version).

Regards,