ROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Tuesday, March 06, 2001 10:25 AM
Subject: Re: Match Records
> >I`m trying to find the best method to match records between two tables in
a
> >MySQL database. But it must match atleast once, so here is a scenario for
you
> >to
>I`m trying to find the best method to match records between two tables in a
>MySQL database. But it must match atleast once, so here is a scenario for you
>to think about.
>
>Member - Job, Salary, Location
>Jobs - Job, Salary, Location
>
>All values will be enum sets in both tables as follows
>
>
SELECT with two (or one) of the three fields - probably with loads of OR's
after the intial search returns 0 rows.
Messy maybe but I don't see any other way.
You can't use a SELECT like you are currently using with fields of the same
name in different tables - I'm surprised you are not throwing
