tag:blogger.com,1999:blog-5291685016268759147.post7079276620599688561..comments2023-06-13T01:25:58.549-07:00Comments on how2java forum: SQL: how do you look for missing ids?javatubehttp://www.blogger.com/profile/15526548399393457583noreply@blogger.comBlogger1125tag:blogger.com,1999:blog-5291685016268759147.post-55123533400313893242012-04-12T23:24:19.825-07:002012-04-12T23:24:19.825-07:00Try with this:
SELECT t1.id FROM your_list t1
LEF...Try with this:<br /><br />SELECT t1.id FROM your_list t1<br />LEFT JOIN your_table t2<br /> ON t1.id = t2.id<br />WHERE t2.id IS NULLjavatubehttps://www.blogger.com/profile/15526548399393457583noreply@blogger.com