Wrox Programmer Forums
Go Back   Wrox Programmer Forums > Database > Oracle
|
Oracle General Oracle database discussions.
Welcome to the p2p.wrox.com Forums.

You are currently viewing the Oracle section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
 
Old August 28th, 2003, 01:49 PM
Authorized User
 
Join Date: Aug 2003
Posts: 15
Thanks: 0
Thanked 0 Times in 0 Posts
Default Microsoft Query and Oracle

I can´t get Microsoft Query to work right in my excel. I am running it against a Oracle database,

trying to run the query:

SELECT tu.unitmaster_id, tu.name, tu.creation_date
        FROM tunit tu, (SELECT max(creation_date) as maxdate, name
                        FROM tunit
                        GROUP BY name) maxresults
            WHERE tu.name = maxresults.name
            AND tu.creation_date= maxresults.maxdate
            AND tu.language='pt'
                ORDER BY NAME

It works fine on SQLNavigator but when I run the same query on microsoft query, it won´t work, saying

it can´t add a select table or something. Can anyone help me with that, I am definitely in need...

Thanks.






Similar Threads
Thread Thread Starter Forum Replies Last Post
ERROR [42000] [Microsoft][ODBC driver for Oracle][ sanjeev jha General .NET 0 June 28th, 2008 12:50 AM
Oracle Stored Procedure and Microsoft Query Raoul Oracle 0 January 23rd, 2006 03:41 AM
Microsoft ODBC for Oracle amjad_mahmood VB Databases Basics 1 August 22nd, 2005 10:33 AM
Microsoft Query and Oracle stored procedure shl007 SQL Language 0 October 21st, 2003 02:43 PM
Microsoft Query and Oracle danielwajnberg SQL Language 4 September 17th, 2003 10:55 AM





Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright (c) 2020 John Wiley & Sons, Inc.