How to check for record which has no entry in another table with some specific value? For example, if we have two tables: Table1 and table 2

Table1 - main table (with unique entry for all records)
table2 - is a history table(where is containg many entries for same record on time stampe basis) (also contains some specific field type)

I need to retreive data like, all data from table1 where there is no entry for the record with type = 'Some vaue'
I typically write this as NOT EXISTS query because this aligns with the wording of the problem ("find everything in table1 where no corresponding row exists in table2")

select t1.* 
from table1 t1
where not exists (select *
                  from table2 t2
                  where t1.id = t2.table1_id
                    and type = 'Some Value');


Depending on your DBMS, mcNets' solutions might be faster - that depends a lot on the query optimizer, in Oracle for example it won't make any difference.