Thread: sql
-
This seems ok in access but is it valid in oracle
select *
from ord_si inner join ord_mm on ord_si.wss_tid = ord_mm.fsi_tid;
Thanks
-
Hi mate,
I believe Oracle does not support the "inner join" syntax which is fair enough as it's really just a simple join.
An sql server query :
select * from a inner join b on a.col1=b.col2;
would be translated to Oracle as
select * from a , b where a.col1=b.col2;
FYI your original query would work on DB2.
Hope this helps
Nick
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|