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')
User Profile
Collapse
-
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.Leave a comment:
-
Comparing data in two tables to find missing records
I have used the script
"select *
from Titles
where not exists(select * from Descriptions where Descriptions.is bn =
Titles.isbn)"
Need to know if i can restrict it to a date range as well.
eg "and date_u > 2011-08-01"
No activity results to display
Show More
Leave a comment: