November 2nd, 1999, 01:22 AM
Ok, excuse the verbose question, but Iím new to MySQL and PHP, and my brain is hurting trying to work through this one in my mind:
I have 3 tables that look something like this:
And I want to create a select which will pull an individual members information across tables (say membername=1) and compare that member to all other members in the database (say membernames = 2 through 9) resulting in an output that would look something like this:
Essentially itís an agreement measure across all fields and all members of the database that needs to be able to be run one member at a time.
Someone told me that I CANíT use a subselect and since then my headís been spinning.
Any help would be appreciated!!!