RE: How to perform JOINs with DBI

From: Ron Reidy (Ron.Reidy_at_arraybiopharma.com)
Date: 07/23/04 

Date: Fri, 23 Jul 2004 11:33:23 -0600
To: "Moreno, Javier" <JavierMoreno@eaton.com>, <dbi-users@perl.org>

Javier,

What does it do in SQL*Plus?

rr

-----Original Message-----
From: Moreno, Javier [mailto:JavierMoreno@eaton.com]
Sent: Fri 7/23/2004 11:31 AM
To: Reidy, Ron; dbi-users@perl.org
Cc:
Subject: RE: How to perform JOINs with DBI
Ron,

This is the Oracle query

SELECT I.idIssue, I.Description, I.idEntry, I.idStatus, E.Description, E.CreateDate, E.idPriority, E.idSeverity, E.idUser, E.DueDate FROM MASTER_Issue I, MASTER_Entry E WHERE I.idIssue = 'I4632362004' AND I.idEntry = E.idEntry

Per Alan Kong's suggestion I tried single quoting the value but that did not work either.

Regards,

Javier Moreno

-----Original Message-----
From: Reidy, Ron [mailto:Ron.Reidy@arraybiopharma.com]
Sent: Friday, July 23, 2004 12:24 PM
To: Moreno, Javier; dbi-users@perl.org
Subject: RE: How to perform JOINs with DBI

Javier,

This is not a DBI issue. What does the query do in SQL*Plus? Is the relationship between the tables mandatory, or should you be using an outer or inner join? 

--
Ron Reidy
Sr, DBA
Array BioPharma, Inc.
-----Original Message-----
From:	Moreno, Javier [mailto:JavierMoreno@eaton.com]
Sent:	Fri 7/23/2004 11:19 AM
To:	dbi-users@perl.org
Cc:	
Subject:	How to perform JOINs with DBI
Hi all,
I am having issues trying to do the following:
SELECT I.idIssue, I.Description, I.idEntry, I.idStatus, E.Description, E.CreateDate, E.idPriority, E.idSeverity, E.idUser, E.DueDate FROM MASTER_Issue I, MASTER_Entry E WHERE I.idIssue = ? AND I.idEntry = E.idEntry
The query runs fine but I get no information back from it. What could be wrong? I ran the same query (replacing the placeholder with the value) on the database and it ran fine and returned information.
Regards,
Javier Moreno
----------------
 <<ole0.bmp>> 
Systems Engineer - Transmissions
"When you have eliminated all which is impossible, then whatever remains, however improbable, must be the truth" - Sherlock Holmes
This electronic message transmission is a PRIVATE communication which contains
information which may be confidential or privileged. The information is intended 
to be for the use of the individual or entity named above. If you are not the 
intended recipient, please be aware that any disclosure, copying, distribution 
or use of the contents of this information is prohibited. Please notify the
sender  of the delivery error by replying to this message, or notify us by
telephone (877-633-2436, ext. 0), and then delete it from your system.
This electronic message transmission is a PRIVATE communication which contains
information which may be confidential or privileged. The information is intended 
to be for the use of the individual or entity named above. If you are not the 
intended recipient, please be aware that any disclosure, copying, distribution 
or use of the contents of this information is prohibited. Please notify the
sender  of the delivery error by replying to this message, or notify us by
telephone (877-633-2436, ext. 0), and then delete it from your system.

Relevant Pages