You are here: Re: should be easy query question « MsSQL Server « IT news, forums, messages
Re: should be easy query question

Posted by Jim on 09/27/57 11:24

In article <1124378850.809509.231910@g44g2000cwa.googlegroups.com>, Tim wrote:
> hi all,
>
> I have a table of customers.
>
> I have a table of products they have ordered.
>
> How can I find all customers who have ordered productA and productB at
> any time.

Do you mean productA AND productB, or productA OR productB?

In other words, do you want clients who have ordered both products, or
all customer who have ordered either product?

One's easy, the other is...less so.

Jim
--
Find me at http://www.ursaMinorBeta.co.uk
"There's no 'I' in team, but there is a 'me' if you jumble
the letters up a bit." - Dr. House.

 

Navigation:

[Reply to this message]


Удаленная работа для программистов  •  Как заработать на Google AdSense  •  England, UK  •  статьи на английском  •  PHP MySQL CMS Apache Oscommerce  •  Online Business Knowledge Base  •  DVD MP3 AVI MP4 players codecs conversion help
Home  •  Search  •  Site Map  •  Set as Homepage  •  Add to Favourites

Copyright © 2005-2006 Powered by Custom PHP Programming

Сайт изготовлен в Студии Валентина Петручека
изготовление и поддержка веб-сайтов, разработка программного обеспечения, поисковая оптимизация