Use of if statments?

[maverik59]

In this query i want to count the number of occurances the staffid is = to the the page id (sometimes its not) is it possible to put in if statements?

SELECT first_name
,last_name
,page
,page_id
,staffid

FROM usertrack
,staff
WHERE page='/staff_details.cfm'
AND staff_id=staffid
if pageid=staffid count(*) AS ownvisit

 

[mwolf00]

SELECT first_name
,last_name
,page
,page_id
,staffid
,count(staffid)


FROM usertrack
,staff
WHERE page='/staff_details.cfm'
AND staff_id=staffid
GROUP BY first_name
,last_name
,page
,page_id
,staffid
HAVING count(staffid) > 0
-----------------------------------------------------------------
"The difference between 'involvement' and 'commitment' is like an eggs-and-ham breakfast: the chicken was 'involved' - the pig was 'committed'."
- unknown

mikewolf@tst-us.com

 

[maverik59]

"HAVING"- Nice one.I'm learning a new command each day and i don't even do SQL. Cheers