Re: Help with MS Access query / SQL, please!

On Thu, 25 Nov 1999 02:08:06 +0000, slpearce01 <slpearce01_at_netscapeonline.co.uk> wrote:

>Hiyah.
>
>I'm struggling with an assignment from university. I've constructed a
>database in Access, consisting of four tables, two of which are
>concerned with the query I'm stuck on.
>
>They are:
>
>A table of 'Orders', with Order#, Member and Item fields.
>A table of 'Suppliers', with Supplier and Item fields.
>
>The query is to find the suppliers that supply all of the items ordered
>by a particular member. I can't work out how to present this in the form
>
>of SQL, which is what's required of the assignment.
>
>I just can't figure this out... can anyone help?
>
>Thanks,
>
>Sarah.
>
>PS Replies by email please

select distinct

		o.member,
		s.supplier
	from
		orders		o,
		suppliers	s
	where
		s.item		= o.item
	and	o.member	= ?
Thanks. Take care, Brian Inglis 	Calgary, Alberta, Canada
-- 
Brian_Inglis_at_CSi.com 	(Brian dot Inglis at SystematicSw dot ab dot ca)
				use address above to reply