On 6 Oct 2003 at 10:26, Louise Cofield wrote:
> I am attempting to select fields Location and Item_Num from table A
> where A.Location = B.Location,
>
> AND
>
> select Item_Description from table C, where A.Item_Num = C.Item_Num.
Try:
select Location, Item_Num
from table A, B, C
where A.Location = B.Location
and A.Item_Num = C.Item_Num
--
Dan Langille : http://www.langille.org/