Good Afternoon! I have a table like this;
id (unique, auto-increment) foo char(6) bar char(10) foo may be duplicated from row to row, bar may be duplicated from row to row i.e. foo bar 949433 IRVINE 949514 NEWPORTBCH 949514 NEWPORTBCH 949533 IRVINE 949533 IRVINE 949633 SADLBK VLY It is OK for 'bar' to have multiple 'foo' that do not match each other. What I want to query for is 'foo' that match each other but have multiple 'bar'. I would like to do this with having to specifiy each 'foo' in turn. Can it be done in one query? Jay -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
