help queries

From: Virgilio Gambarotto <gambarotto_at_greensoft.it>
Date: Mon, 17 Sep 2001 08:51:10 GMT
Message-ID: <2Qip7.47952$F45.492136@news1.tin.it>

Hi
I have a table like this:
car optional
ford 1
ford 2
ford 5

gm      3
gm      1
gm      5

ferrari 1
ferrari 7
Q1
I need to retrieve only cars having optioinals 1 and 5 result must be
ford 1 5
gm 1 5

Q2
I need to retrieve only cars having optioinals 1 and 5 and not 3 result must be
ford 1 5

Tia
i_mac Received on Mon Sep 17 2001 - 03:51:10 CDT