Right > I am still kinda new so I didnt feel like spending a ton of
time trying to fix transfer to work with 8 but its looking like I
might have to do that. Everything in Transfer works fine so far on 8
except when I update my config to use relationships. Any thoughts?

Here is the Join Syntax for 8

select p.part_id, s.supplier_name
from part p, supplier s
where p.supplier_id = s.supplier_id (+);

9+
select p.part_id,s.supplier_name
from part as p
left outer join supplier as s ON s.supplier_id = p.supplier_id


On Dec 1, 11:41 am, "Dan Wilson" <[EMAIL PROTECTED]> wrote:
> Dan,
> Are you talking about the (+) syntax?
>
> I've refactored that syntax out to use the Join Keywords in Oracle 9 & 10,
> though I can't remember if that is valid for 8i. I'm just asking for my own
> benefit...
>
> DW
>
> On Mon, Dec 1, 2008 at 11:14 AM, Dan Vega <[EMAIL PROTECTED]> wrote:
>
> > Is this still unsupported? I have a database that is 8i and didnt
> > realize it was not supported until I was half way through a project.
> > Everything works fine until you get into doing JOINS. Oracle 8i has
> > some funny syntax to create joins and changed over in 9. If its not
> > supported has anyone updated transfer to support this?
>
> --
> "Come to the edge, he said. They said: We are afraid. Come to the edge, he
> said. They came. He pushed them and they flew."
>
> Guillaume Apollinaire quotes
--~--~---------~--~----~------------~-------~--~----~
Before posting questions to the group please read:
http://groups.google.com/group/transfer-dev/web/how-to-ask-support-questions-on-transfer

You received this message because you are subscribed to the Google Groups 
"transfer-dev" group.
To post to this group, send email to [email protected]
To unsubscribe from this group, send email to [EMAIL PROTECTED]
For more options, visit this group at 
http://groups.google.com/group/transfer-dev?hl=en
-~----------~----~----~----~------~----~------~--~---

Reply via email to