in reply to Re: Re: Getting info from 2 tables
in thread Getting info from 2 tables
Hi, I've got two database tables and I'm trying to remove records from the first table that match a value in the second table.
If that's the case, it sounds like what you need is a SQL join. For instance:
(untested SQL code)
Here's the steps to take:SELECT foo_id FROM foo, bar WHERE paco < (waco + 10) AND paco > (waco - 10)
()-() \"/ `
|
|---|