cts (or give some suggestions) to take a
look at?
Thanks!
Chris Blessing
[EMAIL PROTECTED]
http://www.330i.net
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/
Well of course, the sql I gave was simply to demonstrate the table.field
notation.
-C
-Original Message-
From: Jon Gardiner [mailto:[EMAIL PROTECTED]]
Sent: Thursday, October 18, 2001 3:16 PM
To: 'Chris Blessing'; Jessica Tishmack; [EMAIL PROTECTED]
Subject: RE: multiple t
Same thing still applies, just change the table names in the SQL I sent
earlier.
-C
-Original Message-
From: Jessica Tishmack [mailto:[EMAIL PROTECTED]]
Sent: Thursday, October 18, 2001 2:58 PM
To: [EMAIL PROTECTED]
Subject: Re: multiple tables with same fields
> table pets1
> name
You can use the table.field notation like:
select * from cats, dogs where cats.owner = 'lisa' || dogs.owner = 'lisa';
select cats.food, dogs.owner from cats, dogs;
etc. etc.
(note: '||' is the "or" logical operand)
Good luck!
-C
-Original Message-
From: Jessica Tishmack [mailto:[EMAIL
r 18, 2001 10:53 AM
To: Chris Blessing; [EMAIL PROTECTED]
Subject: RE: general sql question
>
> I have a feeling this has something to do with running 3.22
> instead of 3.23.
> ;)
>
> Whadya think?
>
Oops... Yup, according to page 57 of Mr. Dubois' MySQL COUNT() combine
stead of 3.23.
;)
Whadya think?
-Chris
-Original Message-
From: Matthias Ragaz [mailto:[EMAIL PROTECTED]]
Sent: Thursday, October 18, 2001 10:32 AM
To: Chris Blessing; [EMAIL PROTECTED]
Subject: Re: general sql question
>
>select count(distinct(email)) from subscribes;
>
>B
d then count them. I want to be able to do something like:
select count(distinct(email)) from subscribes;
But that's not legal. Any thoughts/ideas you all could send in would be
great. TIA!
Chris Blessing
[EMAIL PROTECTED]
http://www.330i.net
---
