RE: I'm sure this should be simple but I can't get it

2001-09-20 Thread Jay Fesco
> > > > 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 p

RE: I'm sure this should be simple but I can't get it

2001-09-20 Thread Jay Fesco
> 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