Is this a valid sql?

Results 1 to 2 of 2

Thread: Is this a valid sql?

  1. #1
    Fion Guest

    Default Is this a valid sql?

    sql = "select s.staff_name,prj.p_title,(prj.budget-sum(p.totalAmt)) from staff s, project prj, purchase p where prj_staff_id = p.staff_id and prj.p_title = p.p_title group by p.p_title"<BR><BR>especially the group by condition<BR>Thanks

  2. #2
    Join Date
    Dec 1969

    Default RE: Is this a valid sql?

    I thought you had to group by every field in your select..

Posting Permissions

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