Re: SQL select rows conditional on same select

| four | ++---+ and when Z = 3 or 4 or 5, it just returns the single row that I would expect. Again, thanks. Carl > > Carl Franks wrote: > Hi, > > I have 2 tables, "X" and "Y". > > table X table Y > ++---+ +-

SQL select rows conditional on same select

Hi, I have 2 tables, "X" and "Y". table X table Y ++---+ ++---+ | id | title | | id | assoc | ++---+ ++---+ | 1 | one | | 1 | 3 | | 2 | two | | 2 | 3 | | 3 | three | | 2 | 4 | | 4 | four | ++---+ | 5 | five