Programming Forums - View Single Post

taporctv · Jun 5th, 2007, 3:49 PM

Ok I can count now, but my problem is since im joining three tables, im counting from the wrong table. The field i want to count is in the result of my query and in another table from the join. My count function is counting the field from the table i used in the join. How do i count the field in my query results.

Jun 5th, 2007, 3:49 PM	#5
taporctv Newbie Join Date: Mar 2006 Posts: 20 Rep Power: 0	Ok I can count now, but my problem is since im joining three tables, im counting from the wrong table. The field i want to count is in the result of my query and in another table from the join. My count function is counting the field from the table i used in the join. How do i count the field in my query results. Last edited by taporctv; Jun 5th, 2007 at 4:00 PM.