SELECT syntax

[Scott Hamm]

While creating a report, I'm trying to figure out a way to selectively select a category id in SELECT syntax like so:

SELECT
concat(associates.lastname,', ',associates.firstname) as Operator,
mrdaily.kronoshours as Hours,
mrdaily.pto as PTO,
mrcategories.id=1 mrcategories.category as MainStreet,
mrcategories.id=1 mrentries.quantity as QTY,
mrcategories.id=1 mrentries.hours as Hours,
mrcategories.id=2 mrcategories.category as QA Mainstreet,
mrcategories.id=2 mrcategories.quantity as QTY,
mrcategories.id=2 mrcategories.hours as Hours,
etc...
FROM
foo
WHERE
foo
AND