On Thursday 17 January 2002 06:27, Jaime A. Chavarriaga L. wrote:
> Jason
>
> > SELECT * FROM TABLE
> > WHERE sex = 1 OR country = 'CA';
> >
> > Will select all users who are female as well as all users from Canada.
> > You may get duplicate records (for people who are female and from Canada)
> >
Jason
> SELECT * FROM TABLE
> WHERE sex = 1 OR country = 'CA';
>
> Will select all users who are female as well as all users from Canada. You
> may get duplicate records (for people who are female and from Canada) so
you
> may want to use DISTINCT as well.
ok... you are right... but this error
=An alternative approach:-
> > I am building a user search engine. Now I do not know how to gett
> > following:
> >
> > a mandatory field and a voluntary field
> >
> > For example I would like to get all female users and those who are from
> > canada.
> > The results should show all users who are
On Wednesday 16 January 2002 06:05, Andy wrote:
> Hi there,
>
> I am building a user search engine. Now I do not know how to gett
> following:
>
> a mandatory field and a voluntary field
>
> For example I would like to get all female users and those who are from
> canada.
> The results should show