ThresholdID - - - Link to the appropriate threshold being applied to this log entry.
All fields are integers.
The "..." thingies are there to show that these tables hold a lot more imformation than just this. They are set up this way for a reason, and I can't change it at this point.
I need write a SQL statement to select every record from Table1
where the Value field in that particular log record is less than the Threshold field in the linked record of Table2
I'm newish to SQL, so I know this is a basic question.
If anyone can show me how this SQL statement would be structured, it would be greatly appreciated.