Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 Transact-SQL (2000)
 atelast...

Author  Topic 

kandy
Starting Member

15 Posts

Posted - 2006-10-05 : 14:23:29
this is what i need..

a nested query to find the number, last name, and first name of each sales representative who represents at least one customer with a credit limit equal to $5,000.

i have a rep table with rep_num,last_name and first_name and customer table with credit_limit and rep_num.

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2006-10-05 : 14:27:56
Duplicate:
http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=73037

Please stop posting duplicates! You've got like 6 duplicates in 2 days now.

Tara Kizer
Go to Top of Page
   

- Advertisement -