from ody.VHCL_MVS m
inner join ody.VHCL_PLT_HIST p on p.vhc_vhcl_unit_nbr=m.vhcl_vhcl_unit_nbr
where rdy_rnt_agr_nbr = '148685886'
I'm sorry to hear you are having difficulties getting your SQL query to execute correctly... Are you having problems getting this syntax to work correctly in Yellowfin? Have you tested this SQL query against back-end database?
I think you may have some syntax errors, specifically on the following lines:
[quote="">from ody.VHCL_MVS m
inner join ody.VHCL_PLT_HIST p on p.vhc_vhcl_unit_nbr=m.vhcl_vhcl_unit_nbr[/quote]
Can you double check the spacing between 'ody.VHCL_MVS' and 'm', the syntax should be from 'ody.VHCL_MVS AS m' and 'inner join ody.VHCL_PLT_HIST AS p'.
I also recommend testing this query without the where clause to troubleshoot the different sections of your syntax one step at a time.
Anyway, hopefully this information is helpful. Have a great day.
when you say your simple code isn't running, why do you say that? are you getting an error message on the UI, or has the application become unresponsive? Please describe what actually happens when you run your simple code. Also please describe where you are running your simple code...is it a freehand SQL report, or view, virtual table, calculated field, filter query etc?
And if you would like the team at Yellowfin support to review your logs please zip them up and email them to firstname.lastname@example.org making sure to reference the subject of this forum post.