Hi all ,
�����as I came across a certain prob , so I am here ,
���� I have three tables
�1 customer_mast ( custid� pk )
���2���� comment_mast ( multiple comments against custid�, sysdate()
�����3�� contact_mast ( multiple contacts ( three each ) against single
custid , contact id )
� i want to fetch a single record against each customer with last comment
entered� and 1st contact id.
I used the max() but , mysql doesn't accepts usage of max() in where
condition.
I can do this by running two queries but I am looking if there is any
scope of doing this in one single query
any help would be appreciated.
thanks
anup
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
