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:[EMAIL PROTECTED] Sent: Fri 7/23/2004 11:19 AM To: [EMAIL PROTECTED] 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.
<<attachment: ole0.bmp>>
