In the code section below you will find an SQL statement that works, but I want apply one extra "filter" to its result, perhaps by another SELECT statement?
When executing this query, I will get my results, but I want to filter those results out further by only getting records which match a particular test_name.
For example, test_name='aaa' .... how should I modify the query below? Thanks...
SELECT unique_id, test_name, test_object FROM tblSerializedTests
WHERE unique_id IN
(SELECT unique_id FROM tblUserControls