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 ++---+ ++---+ | id | title | | id | assoc

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 |