I am trying to write a query where I pull values from one table where it cant find values in another table with certain criteria
so first table i want
select ordernumber, created_dt, customerID from tbl_customer
where (there isnt an entry in customer comments table with the same ordernumber, created on same date, and with the same customerID in tbl_customerComments as what is selected from tbl_customer)
so for each entry in this query select ordernumber, created_dt, customerID from tbl_customer i want to look in the tbl_customerComments table and see if there is a matching entry with same details, if not then I generate the list.