Grouping Fields

How to group fields

Page 1 of 1

3 Replies - 427 Views - Last Post: 02 April 2009 - 03:14 PM Rate Topic: -----

#1 Raju2047  Icon User is offline

  • D.I.C Head
  • member icon

Reputation: 6
  • View blog
  • Posts: 55
  • Joined: 16-February 09

Grouping Fields

Post icon  Posted 02 April 2009 - 02:54 PM

Re Helloooo,
I m again back with one problem.
I am not much familiar with sql. It's just my starting phase. Any help would be greatly appreciated.
I don't know how to merge the two field and get the single data. I tried this code but its not working.
select SI.FirstName,SI.Lastname as FullName from Supplier_Info As SI where SI.SID = SPurchase.SID


Thanking You
Raju2047
Is This A Good Question/Topic? 0
  • +

Replies To: Grouping Fields

#2 ahmad_511  Icon User is offline

  • MSX
  • member icon

Reputation: 131
  • View blog
  • Posts: 722
  • Joined: 28-April 07

Re: Grouping Fields

Posted 02 April 2009 - 03:04 PM

select SI.FirstName +' ' + SI.Lastname as FullName from Supplier_Info As SI where SI.SID = SPurchase.SID


Was This Post Helpful? 1
  • +
  • -

#3 Raju2047  Icon User is offline

  • D.I.C Head
  • member icon

Reputation: 6
  • View blog
  • Posts: 55
  • Joined: 16-February 09

Re: Grouping Fields

Posted 02 April 2009 - 03:13 PM

Hey, Thank you.
It works.
Was This Post Helpful? 0
  • +
  • -

#4 ahmad_511  Icon User is offline

  • MSX
  • member icon

Reputation: 131
  • View blog
  • Posts: 722
  • Joined: 28-April 07

Re: Grouping Fields

Posted 02 April 2009 - 03:14 PM

:)
Was This Post Helpful? 0
  • +
  • -

Page 1 of 1