Yup.
if you have one column called id, no instances have both the value of 5
and 11, 'cos by definition, they can only have one.
N
Mark Derricutt wrote:
>
> 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
--
Nic Wise - Inprise New Zealand / Brocker Technologies Web Monkey.
mob:+64.21.676.418 - wk:+64.9.481.9999 x9753 - wk-em:[EMAIL PROTECTED]
hm: +64.9.277.5309 - hm-em:[EMAIL PROTECTED]
---------------------------------------------------------------------------
New Zealand Delphi Users group - Database List - [EMAIL PROTECTED]
Website: http://www.delphi.org.nz
