Sitemap

Amicuk Programming Answers

Creating a SQL Expression Formula

2015-10-11   Views:0

Advertisement

Post Author: edt11 CA Forum: Formula I need to due a lookup on name(stored in a different table).  I want to display the name result on the report. I have tried using the following SQL: SELECT distinct(a.short_name) FROM FUND A, FUND_EXTERNAL BWHERE

Post Author: edt11
CA Forum: Formula
I need to due a lookup on name(stored in a different table).  I want to display the name result on the report.
I have tried using the following SQL:
SELECT distinct(a.short_name) FROM FUND A, FUND_EXTERNAL BWHERE A.FUND_NUMBER = B.CUSTODIAN_KEY
And I keep receiving an ORA-00936 error (Missing Expression).  If there is a way to retrieve this info in a normal formula that would be great as well.  But the SQL above gives me the results I am looking for so I didn't exhaust all solutions in the Formula Workshop.
Thanks

The replay answer
Advertisement
Post Author: edt11
CA Forum: Formula
I need to due a lookup on name(stored in a different table).  I want to display the name result on the report.
I have tried using the following SQL:
SELECT distinct(a.short_name) FROM FUND A, FUND_EXTERNAL BWHERE A.FUND_NUMBER = B.CUSTODIAN_KEY
And I keep receiving an ORA-00936 error (Missing Expression).  If there is a way to retrieve this info in a normal formula that would be great as well.  But the SQL above gives me the results I am looking for so I didn't exhaust all solutions in the Formula Workshop.
Thanks

Go to See the other 8 answers

Hot
I have Outlook 2010 set up on Windows 7 using icloud. Outlook synchs to icloud with calendas, contacts, and email. My iPad and iPod touch no longer synch these items. I get a constant rotating whatsit, but no synch on either mobile device. Also, in t [More]
I have some problem when I want to download app in iTunes some security question ask me about my visa when I right my visa number I got an errors and on top of the page told me go to iTunes support I do these things and now what should I doMost of th [More]
Hi SAP gurus, My company has create a down payment, and then create 2 invoice. 1 invoice is use for the VAT. Somehow, the down payment is put into the VAT, not the invoice. The VAT value is less than the down payment. So if we post the payment with a [More]
i'm having trouble getting my new mac mini to provide full resolution to my existing dell u2711 monitor. i purchased the minidisplay to dual link dvi connector (for $100!!) and it still isn't working. i've tried all the trouble-shooting suggestions a [More]
Hi Experts, I want to track the changes done to a material ( like if there are changes to materail description and materail group etc., ) for a given date. Is there any FM which can take the maerail number as input and give out these details. I know [More]
Alright I have a moving marquee ,Its a slideshow with captions on it , I would like to hover over a word in the caption and display a small article in a tool tip An Image and a description , here is the DIV i am using: <div class="marquee_panel_ca [More]
I have a 17in 2010 MacBook Pro w/ CS3 Pro version on it. I need to upgrade to CS6, standard and run them both on the computer temporarily. My specs are OS X 10.6.8; 2.8GHz Intel core 2 duo proc; Memory is 4GB 1067 MHz DDR3. Can I do this? If not what [More]
I have a Form that has 4 cascading List Item after you make a chose on the Bpost_Tag (4th) you press the Button Execute Query. On the Data Block I have PRE-QUERY as shown below! What I'm trying to get in return is if you chose Bpost_Tag 100 you will [More]
We have SAP HANA SPS09. 1) We are using script provided by SAP Note#1651055 to take the data backup.But it seems it is not taking log backup.HOw can we schedule logbackup ? or we have to use DBACOCKPIT or Studio only? 2) My DB is log_mode OVERWRITE.I [More]
this is my first go at imovie, and i was wondering, when it imports my clips from a miniDV tape, where does it store the clips on my HD? i want to be able to burn raw-un-edited DV files to archive as original DV rips off of the tape, but i cant find [More]