> Hi all, > > I'm trying to create a query that returns a set of data based on > two tables. > > A basic description is that If Column A in Table 1 is Equal to Column A in > table 2 then it returns the data from Column B in Table 2. > However, Column A > in Table 1 may contain a list of words that need to be matched > not just one > single entry. > > If someone could point me in the right direction for some code or > a solution > I would be very appreciative. > select Table2.ColumnB from Table1, Table2 WHERE Table1.ColumnA = Table2.ColumnA Jay Fesco Magical Mystery Words: database,sql,query,table --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php