Skip to Content
0
Former Member
Apr 27, 2009 at 01:14 PM

writing alias query with casting

59 Views

Dear Experts,

i want to excute a query which have a condition that needs some casting. the table is MSEG the users are entering the reffrencing article document in the item text field. now all i need is to excute a query which have the mseg aliased and the joining condition should be mblnr with sgtxt

i imagine it should be something like this

select * from recmseg,supmseg where supmseg.mblnr=cast(recmseg.sgtxt as blnr)

recmseg is alias mseg for the recieving site

supmseg is alias Mseg for suplying site

so please can you tell me where i can write it and how to excute it and correct the syntax also