How to get username based on foreign key id in SQL Server

Question

how to get username  from id of cCredit from pls replyselect  cCreditFrom select uusername from Tblusers u TblCredit c where cCreditFromuIdand uIdcUserId and uId29

AnandM · Accepted Answer

Hi  gokuldasRefer below SQL QuerySQLSELECT  uusername  as TransactionWithcUserIdCredit  CASE WHEN cType  39039 THEN 39039 Else Amount EndDebit  CASE WHEN cType  39039 THEN Amount Else 39039 EndSELECT ususername FROM Tblusers us WHERE usUserId  cCreditFrom as ReferenceDt as Date  FROM  TblCredit c Tblusers u  WHERE uId  cUserId AND uId  29 UNION SELECT DISTINCT  Top 10uusername  as TransactionWithcUserIdCredit  CASE WHEN cType  39039 THEN Amount Else 0 EndDebit  CASE WHEN cType  39039 THEN 0 Else Amount EndSELECT ususername FROM Tblusers us WHERE usUserId  cCreditFrom as ReferenceDt as Date  FROM  TblCredit cTblusers uWHERE uId  cUserId AND cType39139 AND uId  29

How to get username based on foreign key id in SQL Server

Company

Explore

Follow us

Contact Us