sql query from Access to Oracle
|
Original Message
|
Name: liliyaw
Date: October 12, 2006 at 07:56:56 Pacific
Subject: sql query from Access to OracleOS: xpCPU/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: