Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- SELECT sr.ServicesResourcesID AS ID, sr.Title, sr.ContactFirstName, sr.ContactLastName, sr.ContactEmail, sr.ContactPhone, sr.FileName, sr.URL, sr.Description AS Description, rt.Type, KEY_TBL.RANK
- FROMvResourceType rt,vServicesResources sr
- INNER JOIN FREETEXTTABLE(ServicesResources, Title, 'computers') AS KEY_TBL
- ON sr.ServicesResourcesID = KEY_TBL.[KEY]
- WHERE sr.ResourceTypeID = rt.ResourceTypeID
- ORDER BY RANK DESC
- SELECT sr.ServicesResourcesID AS ID, sr.Title, sr.ContactFirstName, sr.ContactLastName, sr.ContactEmail, sr.ContactPhone, sr.FileName, sr.URL, sr.Description AS Description, rt.Type, KEY_TBL.RANK
- FROMvResourceType rt,vServicesResources sr
- INNER JOIN FREETEXTTABLE(ServicesResources, Description, 'computers') AS KEY_TBL
- ON sr.ServicesResourcesID = KEY_TBL.[KEY]
- WHERE sr.ResourceTypeID = rt.ResourceTypeID
- ORDER BY RANK DESC
Add Comment
Please, Sign In to add comment