I am struggling a bit on a SQL statement that deals with range of numbers in fields in the database. It goes to $10,000,000. Sales price and LoanAmont will be in a form and posted to the handler page.
If you look at my graphic, let's take this example:
$65,000 - $70,000 has the same Escrow fee. So what if a user picks $68,000 which is not in the database?
So I am not sure if using between is best and then not really sure how to structure that statement. Bottom like, I have SalesPrice in a form input to equal the related fields.
Also not sure if 6 sql statements is best to use (Escrow through ComboLoan)
I am thinking I need 2 sqls because Escrow, ALTAowners and StandardOwners is based on the SalesPrice and LoanAmount uses StandardLoan, AltaLoan and ComboLoan.
Your thoughts would be appreciated.