RE: RE: FN-FORUM: Which Where does a query use if there is more than one?

date posted 21st September 2006 10:38

yep, splitting it into 3 is your best bet if you only want to do one query at a time


>
>Ok I see what you are saying.
>
>How could I write a query to do this
>
>A Car with sunroof AND electric OR a sunroof AND metallic paint OR a sunroof
>AND Leather seats AND metallic paint.
>
>
>
>But I want it to come back with only on of the OR's not all 3
>
>Like this :
> 1 XOR 0 XOR 0
> 0 XOR 1 XOR 0
> 0 XOR 0 XOR 1
>
>To do that I would need spilt the query up into 3 different Queries right?
>
>Thanks for both of your reply.
>
>Jonathan
>