Results 1 to 4 of 4

Thread: Query Problem

Threaded View

  1. Feb 9th, 2008, 12:30 AM #1
    shakti5385
    shakti5385 is offline

    Thread Starter
    Just Married shakti5385's Avatar
    Join Date
    Mar 2006
    Location
    Udaipur,Rajasthan(INDIA)
    Posts
    3,747

    Question Query Problem

    Hi all
    Please look the next problem
    SELECT Student_Name,Attedance,HalfID FROM Table1
    above query providing me following result

    Code:
    Name1,P,1
Name1,P,2
Name1,A,1
Name1,P,2
    Here half Id 1 mean first half and 2 mean second half
    But I want result in followig format

    Code:
    StudentName  FirstHalfAttedance  SecondHalfAttedance
Name1            P                             P
Name1            A                             P
    Last edited by shakti5385; Feb 9th, 2008 at 12:34 AM.
    My Blog : My Article of the day
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

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

Forum Rules


Click Here to Expand Forum to Full Width