i'm currently using the excel vba to query data from oracle database, how can i use the Aliases in sql query with inner join statement.
1. How do i query using aliase?
2. if i use ADODB.Connection and ADODB.Recordset object to establish the connection with oracle database, does it means i need to use oracle syntax query to query data or i can use Ms Access sql syntax to do the query?
select workorder.custpo, shipinfo.lotno shipDetails.shipdate, from (workorder INNER JOIN shipinfo ON workorder.workOrderNo = shipinfo.lotno) inner join shipDetails on shipDetails.shipID = shipInfo.shipID"