Hi All,

I am in sql mode today. Two issues that bother me:

1- I had a script"

select user_id, username from users having user_id = max(user_id)

my max user_id = 150 or something, but script kept bringing 122 

I fixed the issue by using a select max(user_id) and select username from users where 
user_id = $v_user_id

 

2- select max(commission) where territory=1 and salesperson=2232;

this query should return 0 zero b/c it's a sum..... but it returns null.  

any comments how I can work around this!!! 

thanks.


Mehmet Erisen
http://www.erisen.com


---------------------------------
Do You Yahoo!?
Send FREE video emails in Yahoo! Mail.

Reply via email to