• Open Menu Close Menu
  • Apple
  • Shopping Bag
  • Apple
  • Mac
  • iPad
  • iPhone
  • Watch
  • TV
  • Music
  • Support
  • Search apple.com
  • Shopping Bag

Lists

Open Menu Close Menu
  • Terms and Conditions
  • Lists hosted on this site
  • Email the Postmaster
  • Tips for posting to public mailing lists
Re: Left/right Inner join under ms-SQL
[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

Re: Left/right Inner join under ms-SQL


  • Subject: Re: Left/right Inner join under ms-SQL
  • From: email@hidden
  • Date: 27-Apr-2005 10:54:09 MDT




> Hello,
> i use the jdbc driver from microsoft for the MS-SQL 2000 server.
> the driver creates the left or right inner join like this:
>
> Where t0.nr *= t1.nr and so on.

I solved this same problem with DB2 by writing a JDBCPlugin. I don't know
if there is a better way. I can share my code with you if it would help.

There is this plugin, which I assume is for MS-SQL Server
http://developer.apple.com/documentation/WebObjects/Reference/API/com/webobjects/jdbcadaptor/MicrosoftPlugIn.html

Maybe you just need to set your JDBCPlugin value correctly, though the
built-in plugins I thought were supposed to automatically get discovered
and used.

Good luck,
Logan Allred

 _______________________________________________
Do not post admin requests to the list. They will be ignored.
Webobjects-dev mailing list      (email@hidden)
Help/Unsubscribe/Update your Subscription:

This email sent to email@hidden

References: 
 >Left/right Inner join under ms-SQL (From: email@hidden)

  • Prev by Date: Display Null value with Raw Rows
  • Next by Date: Re: Display Null value with Raw Rows
  • Previous by thread: Left/right Inner join under ms-SQL
  • Next by thread: Display Null value with Raw Rows
  • Index(es):
    • Date
    • Thread