Comparing data in two tables to find missing records

[Malstan]

I have used the script

"select *
from Titles
where not exists(select * from Descriptions where Descriptions.isbn =
Titles.isbn)"

Need to know if i can restrict it to a date range as well.

eg "and date_u > 2011-08-01"

[gpl]

what happened when you tried it?

[Malstan]

Hi it still provided all the records. I am not sure where to include the clause as the examples i have seen show it in the brackets.

[Rabbit]

You put it in the where clause. But since it's a date, you'll need to put it in single quotes and it'll do an implicit conversion. Depending on your localization, you may need to change the format that you use. Where I am, I have to put dates in mm/dd/yyyy format.

[ck9663]

Also, depending on which table has the column "date_u", you might need to use an alias to qualify which column from which table you are referring to.


Happy Coding!!!

~~ CK

[Malstan]

Hi

Thanks for the replies so far most appreciated.

I tried the following format but it still extracts all records.

( and t1.dat_u >= '2011-08-01')

[Rabbit]

If that's actually what you put, then it shouldn't even run. It would error out.

This is incorrect syntactically

SELECT *
FROM tableName
WHERE criteria (and criteria)

You have to drop the parentheses or else it will error out. But because it ran, I suspect that's not what you actually put in your SQL.

It also shouldn't run because you are using an alias or qualifier that does not exist in the original SQL you posted.

Without what you're actually using as your SQL, we can't help you. What you're posting can't even run yet you're saying it's returning results.