Hi,
I have two tables
CSAttributeGroup
InventoryItem
am join with two columns entityclassid(String) and Itemclassid(Int)
which are int and string but the data is same
i can able to convert int to string in Sql
but how to do same in BQl
Select * from CSAttributeGroup A Join InventoryItem B on A.EntityClassID = cast(B.ItemClassID as varchar(15))
Or A.EntityClassID = B.LotSerClassID
Where B.CompanyID =2 and A.CompanyID=2 and ( A.EntityClassID ='106' or A.EntityClassID='LREX') and B.InventoryID=10759
Please Suggest me with the answers
Thank you