Results 1 to 2 of 2

Thread: How do i join two table to get a row count...?

  1. #1
    Join Date
    Dec 2011
    Posts
    1

    How do i join two table to get a row count...?

    Hi


    select D.ID,D.FOOD_ID,F.NAME from DISLIKE_FOOD D Inner join FOOD F on D.FOOD_ID=F.ID and DIS_ID =581
    group by D.ID,D.FOOD_ID,F.NAME

    this is my inner join query ...i need count of rows....
    please help me....

    thanks & regards
    phani

  2. #2
    Join Date
    Sep 2002
    Posts
    5,938
    select @@rowcount

Posting Permissions

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