quote:

---

Originally posted by Ichiro Sato

im supposed to output the companies that have commission rates highter than company "Industrial Appparatus".
is there some whay to modify this code so that it will work?
commissionrate > ALL(Select commissionRate From salescompanydomestic Where companyName = 'Industrial Appparatus')

---

SELECT * FROM YourTable
WHERE commissionrate > (SELECT MAX(commissionrate) From salescompanydomestic Where companyName = 'Industrial Appparatus')

quote:

---

Originally posted by Ichiro Sato

I have two tables that I am using for this query
SalesCompany
companyId companyName salesNetworkIndicator
----------- ------------------------------ ---------------------
111 Industrial Appparatus D
222 AIE Inc D
333 Chalman Technologies D
444 Langley Macinery D
555 Electronic Assembly Products D
666 KDF Company D
777 AKA Northern Asia I
888 Algon EAPRO I
999 Algon France I
1000 3D Automation India I
1100 Enlaces Industriales I
1200 Townsend Coates Ltd I

(12 row(s) affected)

SalesCompanyDomestic
companyId state phone commissionRate
----------- -------------------- -------------------- ---------------------------------------
111 Alabama 770-9191913 0.0300
222 Alaska 425-4554697 0.0500
333 California 714-5651234 0.0100
444 Florida 352-1234343 0.0200
555 Utah 303-1235465 0.0400
666 Ohio 440-9897867 0.1000

(6 row(s) affected)

---

SELECT *
FROM SalesCompanyDomestic scd
INNER JOIN SalesCompany sc
ON sc.companyId=scd.companyId
WHERE scd.commissionRate >
(
SELECT scd.commissionRate
FROM SalesCompanyDomestic scd
INNER JOIN SalesCompany sc
ON sc.companyId=scd.companyId
AND sc.CompanyName='Industrial Appparatus')