Re: [DUG-DB]: A tricky SQL problem

[Mark Derricutt]

On Thu, 4 Nov 1999, Nic Wise wrote:

> select name from table where id = 5
> intersect
> select name from table where id = 11

wouldn't

  select distinct name from table where id = 5 and id = 11 

work?  or am i missing some vital, and obvious thing?

-- 
Mark Derricutt
Now Playing: Switchblade Symphony - The Three Calamities

---------------------------------------------------------------------------
  New Zealand Delphi Users group - Database List - [EMAIL PROTECTED]
                  Website: http://www.delphi.org.nz