need help for QUERY...

[Guest_imported]

hi i have a problem with converting a SQL command to CF.

what im trying to perform is :

SELECT S.Organization, S.OrganizationURL, S.ShortDescription
FROM SupplierDirectory S, SupplierGeneralCategory
Where S.ID = SupplierGeneralCategory.SupplierID and
SupplierGeneralCategory.GeneralCategory = 'Assessment'

thats the SQL command for it. However no matter how hard i try i can't convert it to CF. i have two tables, i want it to search through SUPPLIERDIRECTORY, and find entries with CATEGORY = assessment (in SupplierGeneralCategory) and show the results.

can anyone translate what i wrote down to pure CF ??


thanks alot,
BB

 

[Guest_imported]

ahhh.... n/m folks !! i got it to work...

SELECT Organization, OrganizationURL, ShortDescription
FROM SupplierDirectory, SupplierGeneralCategory
WHERE GeneralCategory='Assessment' and
SupplierDirectory.ID=SupplierGeneralCategory.SupplierID