sql
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2

Thread: sql

  1. #1
    Join Date
    Feb 2001
    Posts
    107
    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

  2. #2
    Join Date
    May 2002
    Location
    Western Australia
    Posts
    233
    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
  •  



Click Here to Expand Forum to Full Width