Alias Question

[kool_samule]

Hi Chaps,

Have a quick one for you...

In a SQL Query, I know you can create an alias for column name, eg.

...tbl_jobxml.job1 as job2

but can you create an alias for the value within that column, eg.

...tbl_jobxml.job1='y' as job2='Complete'

Sorry if this is dumb question, but better to ask that claim ignorance!

????

[crmalibu]

select 'Complete' as job2

[kool_samule]

sorry to the delay in responding, basically this is what I want to do:

I want to show all results when:

- tableA
projectstatus='complete'

- tableB
projectstatus='complete'

- tableC
jobstatus='y'

I'm familiar with UNIONs and INNER JOINs, it's just not sure how to go about getting all the results form the 3 tables, when the values are different.

[guido2004]

SELECT
   ...
FROM tableA
INNER JOIN tableB
ON ...
INNER JOIN tableC
ON ...
WHERE tableA.projectstatus = 'complete'
AND   tableB.projectstatus = 'complete'
AND   tableC.jobstatus = 'y'

[r937]

nice job, guido

i was busy answering this same question on two other forums, so you beat me to it here on sitepoint

samule, you can save yourself some effort by posting only here at sitepoint, we have all the best database guys right here