>
To: "Bill Easton" <[EMAIL PROTECTED]>
Cc: <[EMAIL PROTECTED]>
Sent: Monday, December 06, 2004 11:05 AM
Subject: Re: Yet another LEFT JOIN question
> > If you are using 4.1 or later, you could do a subquery to count the
> > clicks,
> > then left join that w
do a subquery to count the
clicks,
then left join that with the views.
HTH
Bill
From: Ron Gilbert <[EMAIL PROTECTED]>
Subject: Yet another LEFT JOIN question
Date: Sat, 4 Dec 2004 12:08:43 -0800
I have three tables, 'Ads' is a list of ads, 'Clicks' is a simple list
of
t the clicks,
then left join that with the views.
HTH
Bill
From: Ron Gilbert <[EMAIL PROTECTED]>
Subject: Yet another LEFT JOIN question
Date: Sat, 4 Dec 2004 12:08:43 -0800
I have three tables, 'Ads' is a list of ads, 'Clicks' is a simple list
of every time a Ad was
: Ron Gilbert [mailto:[EMAIL PROTECTED]
Sent: Saturday, December 04, 2004 2:09 PM
To: <[EMAIL PROTECTED]> <[EMAIL PROTECTED]>
Subject: Yet another LEFT JOIN question
I have three tables, 'Ads' is a list of ads, 'Clicks' is a simple list
of every time a Ad was
I have three tables, 'Ads' is a list of ads, 'Clicks' is a simple list
of every time a Ad was clicked on with the Ads ID, and 'Views' is a
simple list of views that ad got, with the Ads ID.
I am trying to SELECT a list of all the ads, with a count for clicks
and a count for views, but my LEFT J
- Original Message -
From: "Richard Reina" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Thursday, October 14, 2004 8:26 AM
Subject: left join question
> Is it possible to do two left joins involving three
> tables in one query?
>
> select a.id,
[snip]
Is it possible to do two left joins involving three
tables in one query?
select a.id, a.amount FROM t1
LEFT JOIN t2 ON (t1.id=t2.id)
then
LEFT JOIN t3 ON (t1.id=t3.id)
Is this even possible?
[/snip]
Yes, and the keys from table to table don't have to be the same, save
for each JOIN..
S
Is it possible to do two left joins involving three
tables in one query?
select a.id, a.amount FROM t1
LEFT JOIN t2 ON (t1.id=t2.id)
then
LEFT JOIN t3 ON (t1.id=t3.id)
Is this even possible?
Any help would be greatly appreciated.
Richard
--
MySQL General Mailing List
For list archives: http
You only need to specify from tabel on the first table. Like this.
select
cattbl.name as cat, dogtbl.name as dog, birdtbl.name as bird
from dogtbl
left join cattbl on cattbl.id=dogtbl.catid
left join birdtbl on birdtbl.dogid=dogtbl.id;
-Eric
On Mon, 5 Jul 2004 09:28:02 -0700, bruce <[EMAIL PRO
On Monday 05 July 2004 12:28 pm, bruce wrote:
> my test tbls
>
> cattbl dogtbl birdtbl
> namename name
> id ---> catid ---> dogid
> id id
>
> so
> dogtbl.catid = cattbl.id
> birdtbl.dogid = dogtbl.id
>
> my question is how i can use "
my test tbls
cattbl dogtbl birdtbl
namename name
id ---> catid ---> dogid
id id
so
dogtbl.catid = cattbl.id
birdtbl.dogid = dogtbl.id
my question is how i can use "left joins" to produce the results set with the names of
all thre
-
From: "D. R. Hansen"
Sent: Wednesday, October 15, 2003 3:39 PM
Subject: ALTER TABLE z ADD INDEX... Speed: Follow up to LEFT JOIN
question
> What amount of time is reasonable to expect for indexing an FK int
field on
> a simple table with about 30K records. It's running on my &
CPU or disk activity (and it's not from other things...),
then it's not hung. Just sit and wait. :-)
Matt
- Original Message -
From: "D. R. Hansen"
Sent: Wednesday, October 15, 2003 3:39 PM
Subject: ALTER TABLE z ADD INDEX... Speed: Follow up to LEFT JOIN
question
&
What amount of time is reasonable to expect for indexing an FK int field on
a simple table with about 30K records. It's running on my "learning"
machine -- an aging Pentium 5/133 box running RH 8 which is ordinarily
quite fast enough for my purposes. It's been running about six hours now,
and
Hi all;
I was given a query today of the following:
SELECT record_id, record_title,artist_name,label_name,record_catalog
FROM record_profile
LEFT JOIN artist_profile,label_profile
ON record_profile.artist_id = artist_profile.artist_id OR
record_profile.label_id = label_profile.label_id
GROUP BY r
That does it! Thanks much.
Jim
On Saturday, March 29, 2003, at 06:14 PM, Bruce Feist wrote:
Jim Miller wrote:
I want to do a join and select of these tables that will give me all
the Entrants who did NOT enter contest 1 (i.e., Mary and Bill).
Try:
select entrant.name
from entrant le
Jim Miller wrote:
I want to do a join and select of these tables that will give me all
the Entrants who did NOT enter contest 1 (i.e., Mary and Bill).
Try:
select entrant.name
from entrant left join contestEntries
on entrant.id = contestEntries.entrant AND
contestEntries.ContestN
This is probably a real newbie question, but, since that's what I am...
Using MySQL 3.23, I have two tables, for instance:
ContestEntries: id, entrant, contestNumber, etc.
Entrant: id, name, etc.
There are multiple contests, and Entrants can enter as many as they
like. So, Entra
Hi.
On Fri 2002-07-19 at 11:15:00 -0400, [EMAIL PROTECTED] wrote:
> I have a table of members that includes a status flag and a history
> table of activities that includes a date. What I need is all members
> with a particular status and their activites (which may be none) for
> some date range.
I'm a bit new to this, so bear with me if it seems obvious. :)
I have two tables the content of which I'd like to display in a single
result, ordered by content of fields that have similar content but
different names in the two tables.
This is as far as I've gotten:
SELECT invoice.invdate AS
20 matches
Mail list logo
