On Friday 20 February 2004 15:19, Claire Lee wrote: > Hi All, > I have a query problem here. Say I have a table with > employee records of three different departments. If > each department manager wants to see employee info of > their own department. Three different queries will be > needed. Is there a way that I can write one single > query and let SQL decide which department info to > display at the run time? Thanks.
What language are you doing this in? You should be able to provide the appropriate 'where' clause when generating the query. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]