LifeinAsia - 4:24 pm on Mar 14, 2013 (gmt 0)
this query is VERY slow and doesn't seem to do as I expect.
As phranque said, make sure you're properly indexed. Also, is ID_number an INT field or VARCHAR? (Searching on INTs is almost always faster than VARCHARs.) Also, how many rows are in each table?