>>=====> Need help with a SQL select statement <=====<<

I believe I once saw someone do the following:

Table A:          DeptNo         EmpNo
                  ---------      --------
		  10             2121
	          10             2125
		  10             2129
 		  20             2145
	          20             2150
                  30             2200
                  30             2300 

I want to write a SQL statement to select from Table A all EmpNo where DeptNo = 20. AND have the results come back on one resultant row.         

        Desired format: 2145 2150

	NOT of the normal format:  2145
	  			   2150

I can not find my notes on this. Any help would be greatly appreciated.

Thanks.......... Art Received on Thu Oct 17 1996 - 00:00:00 CEST