Posted by Erland Sommarskog on 08/18/05 00:32

 (a@b.com) writes:
> jesus christ! how much more "bare minimum" does this get:
>
> "all tables have a varchar(50) column called uniqueId. the lineitem and
> auxiliary tables have an additional varchar(50) column called
> parentUniqueId...i'm trying to get only those related items where neither
> poId, lineId, nor auxId are in a list of supplied values."
>
> there is *no* guessing involved. not only have i provided the structure
> for each table, their relation to eachother, a sample of what their data
> looks like, but i've even written 90% of the goddamn query...i need help
> with the criterion! can no one do that?!!

I read your previous post, but I failed to comprehend:

i'm trying to get only those related items where neither poId, lineId,
nor auxId are in a list of supplied values. i.e. if the list was "QRS",
then the above records *should* show. if the list was "L" for example,
then none of the data above should show...since L is either a poId,
lineId, or auxId - which is the actual case here.

It may be obvious to you, but it is not to me why none of the rows
would be selected when L is in the list.

You may know your business rules and business domain - we don't. And
if you fail to explain me, it's getting difficult to write a query
for you. I mean, you know the business rules, but can still not write
the query.

Anyway, it's all up to you. If you prefer to yell "Jesus Christ",
rather than helping us to help you, please do so.


--
Erland Sommarskog, SQL Server MVP, esquel@sommarskog.se

Books Online for SQL Server SP3 at
http://www.microsoft.com/sql/techinfo/productdoc/2000/books.asp

[Back to original message]