son Lima [mailto:weys...@gmail.com]
Sent: Wednesday, April 21, 2010 10:51 AM
To: mysql@lists.mysql.com
Subject: Join issues
I am dealing with a JOIN error issue. The following query:
SELECT *
FROM (((ts_software RIGHT JOIN t_computers ON
t_softwareassoc.SoftwareAssocSoftwareID = ts_software.So
I am dealing with a JOIN error issue. The following query:
SELECT *
FROM (((ts_software RIGHT JOIN t_computers ON
t_softwareassoc.SoftwareAssocSoftwareID = ts_software.SoftwareID) LEFT JOIN
ts_softwaremfg ON
ts_software.SoftwareMfgID = ts_softwaremfg.SoftwareMfgID) LEFT JOIN
ts_eqtype ON
t_compute
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
bject: RE: left join issues!!!
i think my problem is that the parsefileTBL will have null values for the
userID for some rows. the userID is the join for the userTBL. as i stated,
this is ok, as i would like to be able to display whether or not the
parsefileTBL/university_url has a person
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.
NULLs.
Hope this helps :)
Regards,
Lachlan
-Original Message-
From: bruce [mailto:[EMAIL PROTECTED]
Sent: Tuesday, 10 August 2004 7:16 AM
To: [EMAIL PROTECTED]
Subject: left join issues!!!
hi...
sorry for the length of this post!!
i have the following, that i somehow managed to
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
hi...
sorry for the length of this post!!
i have the following, that i somehow managed to get working at some point,
but i've screwed it up!!!
basically i have a number of tables, that i'm trying to join. the tables
are:
universityTBL(
name varchar(50) not null default '',
city
Hello,
I am trying to figure out a problem I am having with a query involving
multiple joins but am not having much luck.
I currently have this query working:
db1 LEFT JOIN db2 ON db1.files_groupId = db2.group_id
LEFT JOIN db3 ON db1.files_userId = db3.user_id
Basically the above is
17 matches
Mail list logo