*********************************************************************************** WESTMINSTER CITY COUNCIL
Delivering Civic Renewal through leadership, excellence, partnership, innovation and service. Find out more at www.westminster.gov.uk *********************************************************************************** Further to my query, I have been checking the user forum database of the previous issues regarding extracting data from ORACLE and table joins and have come across a suggestion to use 'owner.tablename' in the query. This is as described in message 7963, by Dale Lutz. I have done this, subsstituting . for _ after uni7live who is the defined as the owner in all_tables. However, the results are still the same. I do not get my expected single row selection but the entire contents of both tables. I am using FME 2004, so would assume that the earlier problems have been fixed. The issue is that FME is ignoring the "where" and "and" clauses in the SQL select statement. Any assistance in resolving this issue will be greatly appreciated, Thanks, Oswin Remedios City of Westminster > -----Original Message----- > From: Remedios, Oswin > Sent: 24 June 2005 10:43 > To: '[email protected]' > Subject: Problem extracting from ORACLE - SQL format for use in > SQLExecutor > > I would appreciate advice on the SQL format to use when using SQLExecutor. > The SQL string appears to be ignored when the ctrl/r is activated and the > contents of both tables are selected instead. The SQL string as follows > returns the content of the entire file instead of the single row expected. > > "select > uni7live_pr_blpu.keyval,uni7live_pr_blpu.uprn,uni7live_pr_blpu.map_east,un > i7live_pr_blpu.map_north,uni7live_pr_lpi.pkeyval,uni7live_pr_lpi.address > from uni7live_pr_blpu,uni7live_pr_lpi > where uni7live_pr_lpi.pkeyval=uni7live_pr_blpu.keyval > and uni7live_pr_blpu.uprn='999000151468'" > The FME workbench file is attached. > Thanks, > Oswin > <<database2csv.fmw>> > > ********************************************************************** Westminster City Council switchboard: +44 20 7641 6000 ********************************************************************** This E-Mail may contain information which is privileged, confidential and protected from disclosure. If you are not the intended recipient of this E-mail or any part of it, please telephone Westminster City Council immediately on receipt. You should not disclose the contents to any other person or take copies. ********************************************************************** Get the maximum benefit from your FME, FME Objects, or SpatialDirect via our Professional Services team. Visit www.safe.com/services for details. Yahoo! Groups Links <*> To visit your group on the web, go to: http://groups.yahoo.com/group/fme/ <*> To unsubscribe from this group, send an email to: [EMAIL PROTECTED] <*> Your use of Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/
database2csv.fmw
Description: Binary data
