|
|
 |
|
|
|
statename Profile & listings. Select a City link to find a private carrier trucking comopany closer in your area.
Go Back
Home > Find a Private Carrier Trucking Job > statename |
|
SELECT * FROM CLASSIFIED_DATA CD, COMPANY C WHERE CD.COMPANY_ID = C.ID AND CD.ITEM_CATEGORY_ID = 26 AND CD.STATUS_ID = 'ACT' AND CD.STATE_CD LIKE '%|Connecticut|%' OR CD.COMPANY_ID = C.ID AND CD.ITEM_CATEGORY_ID = 26 AND CD.STATUS_ID = 'ACT' AND CD.STATE_CD LIKE '%|Connecticut|%' OR CD.COMPANY_ID = C.ID AND CD.ITEM_CATEGORY_ID = 26 AND CD.STATUS_ID = 'ACT' AND CD.STATE_CD LIKE '%|Connecticut|%' ORDER BY C.REVENUE DESC, C.COMPANY_NAME ASC |
| |
|
|
|
|
|
|
|
|
|
|
|
|
|