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
Dear all, I had a problem while taking printout in FBL1N transaction . wheever i am taking  a printout one block of ALV is coming in one page. The alv is grouped according to vendor and Company code. with is_sort-group = '*'.  I read so many forms an [More]
Hi all, I am preparing to migrate from the cuddly world of iPhoto into the big bad world of Aperture. During the transition I was hoping to continue using both programs (especially given the excellent photobook and slideshow functions of iPhoto) and [More]
Hi, My web application (asp.net mvc) provides a 'webcals' link that users can import into outlook and add a calendar from the app. This was all working fine a week ago. I updated the webapp to be accessed exclusively over ssl and now the functionalit [More]
Q - How do I create a Photoshop Droplet that can be used in the Lightroom Export's "Post-Processing" pop-up? A - Victoria Bampton has written an excellent tutorial that answers this question. The tutorial can be found hereYou could use... app.Vi [More]
I am waiting for adobe reply on open case 0210885939. My user # is 114057269.Try sub-forum http://forums.adobe.com/community/photoshopRead other 2 answers [More]
On my drop down list in my library in i Tunes, I don't see a Photo tab.  How do I find that so I can download photos from my hard drive?No, not on the File menu. Click on the Device that shows up when connected: Either: If you do not use the Sidebar, [More]
Since the upgrade to Yosemite a few days ago I noticed that the "Merge Cards" button prior versions used to offer has disappeared. While a "Find Duplicates" function is available, I have had problems with it in the past in part due to [More]
Hi all, when I run the file dialog in 6i, it seems to default its position (the pop-ups left/top corner) to the left side and below the title bar of the calling vi's front panel. I'm running on win 2000 Is this normal behavior? Can I alter this someh [More]
I am facing problems with mails after update iPhone 4S/io7. I have configured yahoo mail in iPhone 4S. When I click on refresh, it shows new mail downloaded but when I go inside inbox the new mail don't show up. Can anyone help me with this iOS 7 iss [More]
I accidentally linked onto to someone's wifi for around 20 seconds to look at google maps is there any chance that person could have seen or accessed the photos on my phone? Or am I just over reacting? Need to ask ad apple didn't give me any info on [More]