004 11:17 PM
To: [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]
Subject: RE: left join issues!!!
Bruce,
I have reconstructed the database you have given me and used the following
query successfully (the one I originally gave you). I think there is
something wrong with your data.
SELECT
p2.
Bruce,
I'm getting the four rows with one correctly matching the userID for tom and
the others returning NULLs for the user info.
Lachlan
-Original Message-
From: bruce [mailto:[EMAIL PROTECTED]
Sent: Tuesday, 10 August 2004 5:13 PM
To: 'Lachlan Mulcahy'
Subject: RE: l
Bruce,
I have reconstructed the database you have given me and used the following
query successfully (the one I originally gave you). I think there is
something wrong with your data.
SELECT
p2.statusID as parseStatus,
p2.action as parseAction,
u2.name,
p1.userID,
Original Message-
From: Lachlan Mulcahy [mailto:[EMAIL PROTECTED]
Sent: Monday, August 09, 2004 8:04 PM
To: [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]
Subject: RE: left join issues!!!
Bruce,
Try building your join table by table.. start with
SELECT
fields
FROM
fields and slowly add them
until you have the lot..
This is a good technique to find where your joins are going wrong.
Regards,
Lachlan
-Original Message-
From: bruce [mailto:[EMAIL PROTECTED]
Sent: Tuesday, 10 August 2004 12:27 PM
To: 'Lachlan Mulcahy'
Subject: RE: left j
NULL1
158 NULL2
159 NULL3
160 1 4
userTBL
nameid
tom 1
this is a sample of what the db/tbl looks like for
auburn/universityTBL.ID=40
-Original Message-
From: Lachlan Mul
x27;s the rough structure of the db/tables...
right now i have ~2000 records in the universityTBL...
-Original Message-
From: Lachlan Mulcahy [mailto:[EMAIL PROTECTED]
Sent: Monday, August 09, 2004 6:02 PM
To: [EMAIL PROTECTED]
Subject: RE: left join issues!!!
Bruce,
What do you ge
PM
To: [EMAIL PROTECTED]
Subject: RE: left join issues!!!
Bruce,
A couple of questions...
Do you always expect one or more entries in the university_urlTBL for a
universityID that is in the universityTBL? If so, then you don't need to
left join the university_urlTBL from the universityTB
Bruce,
What do you get when you do this:
SELECT
*
FROM
university_urlTBL
WHERE
universityID = 40;
Lachlan
-Original Message-
From: bruce [mailto:[EMAIL PROTECTED]
Sent: Tuesday, 10 August 2004 10:46 AM
To: 'Lachlan Mulcahy'
Subject: RE: left join iss
assigned to it...
-Original Message-
From: Lachlan Mulcahy [mailto:[EMAIL PROTECTED]
Sent: Monday, August 09, 2004 5:21 PM
To: [EMAIL PROTECTED]
Subject: RE: left join issues!!!
Hi Bruce,
I haven't reconstructed your database to test for sure, but I think your
problem is stemming from th
Message-
From: Lachlan Mulcahy [mailto:[EMAIL PROTECTED]
Sent: Monday, August 09, 2004 5:21 PM
To: [EMAIL PROTECTED]
Subject: RE: left join issues!!!
Hi Bruce,
I haven't reconstructed your database to test for sure, but I think your
problem is stemming from the way your joins are working.
Hi Bruce,
I haven't reconstructed your database to test for sure, but I think your
problem is stemming from the way your joins are working.
First of all, since you are left joining to the university_urlTBL, you will
also need to left join to any tables you join from that table. If you don't
do th
followup to my initial question.
i can use the following select query to get close... however, it doesn't
really use 'left joins', and i can't figure out how to arive at the results
with the user names being correctly identified.
mysql> select
-> p1.name as pname,
-> p2.statusID as ps
13 matches
Mail list logo