Ive got a table, where the columns / fields A & B are what im selecting

Column A, is a reference,

Column B - is a Username...


There could be multiple references to a username...

Eg

1 john
3 john
7 john


and also, multiple usernames per reference

EG

3 John
3 Jane
3 Sam


My question, - Is there a way to get ALL the references for a
particular Username, and THEN - to find all the usernames which match
ANY / ALL of the refereces matched with the first username..

- Preferably within the one Select command.

PS - I think the UNION command is what I need, however all the
examples I see are insufficient - for me to make this go. -

(still researching)...

--
G
Yahoo Archives by email = Yes
http://groups.kwister.com/owners.php#add
NZ community groups - [EMAIL PROTECTED]


Community email addresses:
  Post message: [email protected]
  Subscribe:    [EMAIL PROTECTED]
  Unsubscribe:  [EMAIL PROTECTED]
  List owner:   [EMAIL PROTECTED]

Shortcut URL to this page:
  http://groups.yahoo.com/group/php-list




SPONSORED LINKS
Php mysql Job postings


YAHOO! GROUPS LINKS




Reply via email to