Computing.Net > Forums > Database > sql query from Access to Oracle

sql query from Access to Oracle

Reply to Message Icon

Original Message
Name: liliyaw
Date: October 12, 2006 at 07:56:56 Pacific
Subject: sql query from Access to Oracle
OS: xp
CPU/Ram: 250
Comment:

Could anyone tell me what this query would be like converted to Oracle? Thanks in advance.

SELECT tblBlock.* FROM tblBlock INNER JOIN tlkpLocation ON tblBlock.LocCode=tlkpLocation.LocCode
WHERE (((tblBlock.OBID) Like [forms]![frmBlock]![cboSelOBID]) And
((tblBlock.LocCode) Like [forms]![frmBlock]![cboSelLoc]));


Report Offensive Message For Removal







Use following form to reply to current message:

   Name: From My Computing.Net Settings
 E-Mail: From My Computing.Net Settings

Subject: sql query from Access to Oracle

Comments:

 


  Homepage URL (*): 
Homepage Title (*): 
         Image URL: 
 
Data Recovery Software