Results 1 to 2 of 2

Thread: Query

  1. #1
    Join Date
    Dec 1969

    Default Query

    I have two tables<BR><BR>LOGIN_MASTER(user_id,user_name,U_cod e,usr_email)<BR>open_CC(cc_id,U_Code)<BR><BR>I am trying to write a query which will display both CC_id,usr_email where U_code=U_code in one single column..I don&#039;t want<BR>usr_email and CC_id two differant columns.. I want to display in one single column..<BR><BR><BR>

  2. #2
    Join Date
    Dec 1969

    Default RE: Query

    SELECT usr_email + &#039; &#039; + CC_id as UserNameAndCC FROM Login_Master L INNER JOIN open_CC O on L.U_code = O.U_code

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts