Wrox Programmer Forums
Go Back   Wrox Programmer Forums > Database > Oracle
| Search | Today's Posts | Mark Forums Read
Oracle General Oracle database discussions.
Welcome to the p2p.wrox.com Forums.

You are currently viewing the Oracle section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
  #1 (permalink)  
Old August 24th, 2003, 01:16 AM
NK NK is offline
Registered User
 
Join Date: Jul 2003
Location: Centurion, Guateng, South Africa.
Posts: 2
Thanks: 0
Thanked 0 Times in 0 Posts
Default Query to be run against both SQL and Oracle


Hi
I've been made aware that in Oracle 8 db, outer and inner joins donot work.
How can use the foll query to work against both dbs.

SELECT AppUser.Forename, AppUser.Surname, AppUser.ID
FROM Training_Course_AppUser LEFT OUTER JOIN
AppUser_TrainingCourse ON Training_Course_AppUser.AppUser_ID = AppUser_TrainingCourse.AppUser_ID AND
Training_Course_AppUser.Course_ID = AppUser_TrainingCourse.Course_ID RIGHT OUTER JOIN
AppUser ON Training_Course_AppUser.AppUser_ID = AppUser.ID
WHERE Training_Course_AppUser.Course_ID = 125 And AppUser_TrainingCourse.Completion_Date Is Null


regards
N
  #2 (permalink)  
Old April 22nd, 2004, 03:34 AM
Authorized User
 
Join Date: Aug 2003
Location: , , Malaysia.
Posts: 16
Thanks: 0
Thanked 0 Times in 0 Posts
Default

why don't you try (+) or union syntax to combine both tables

  #3 (permalink)  
Old April 26th, 2004, 05:28 PM
Authorized User
 
Join Date: Apr 2004
Location: Boise, ID, USA.
Posts: 70
Thanks: 0
Thanked 0 Times in 0 Posts
Default

If you're doing an outer join, the problem is that Oracle doesn't support the SQL 99 syntax until 9i and SQL Server doesn't support the Oracle join operator (+).

What API are you using to execute the query? The ODBC API defines an escape sequence for outer joins that the individual ODBC drivers will convert to the appropriate native join syntax.

Justin
Distributed Database Consulting, Inc.
http://www.ddbcinc.com/askDDBC


Similar Threads
Thread Thread Starter Forum Replies Last Post
How to run ASP.Net with Oracle 9i ramk_1978 ASP.NET 1.0 and 1.1 Professional 1 September 7th, 2006 08:07 PM
Executing a query from SQL server to Oracle DB SoCalProgAna SQL Server 2000 7 March 24th, 2006 08:15 AM
Looking for a SQL Query Builder for ASP.Net/Oracle rashid_masud SQL Language 0 March 9th, 2006 06:37 AM
How to load & run a oracle script file? hapytran C# 0 October 12th, 2005 11:47 PM
Set query up to automatically run in SQL server ALLA SQL Server 2000 3 October 21st, 2004 04:24 PM





Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright (c) 2020 John Wiley & Sons, Inc.