Menu
I have a column which needs to be populated with ture/false/(N/A) data. This column is part of a select statement So, How can i achieve this?
SELECT distinct
program_id,
prog_name,
Eitc_Active_Switch as Prog_Status,
progmap.client_id,
progmap.ORG_ID,
sec.calwinexists_ind as interface,
sec.Client_name
FROM ref_programs prog (nolock)
LEFT OUTER JOIN ref_county_program_map progmap (nolock)
ON progmap.program_id=prog.prog_id AND progmap.CLIENT_ID=prog.CLIENT_ID
INNER join sec_clients sec (nolock)
on sec.client_id=progmap.Client_id
'sec.calwinexists_ind as interface' is the column. the true/false should be displayed for only three records (AMC, AMBD, ACMNI) and 'N/A' for the rest of the records
Can anyone help me?
408
This isn't what the requester wanted, but is very useful to know that you can use if statements outside a select statement. EXISTS is good because it kicks out of the search loop if item is found. A COUNT runs until the end of table rows.
To add a condition, create a row in the Query Conditions list for the appropriate field from the Entity List pane. To add an AND condition, select the AND radio button in the Query Conditions title bar and do one of the following: Select an entity from the Entity List pane and select Add Condition from the pop-up menu.
Conditional statements are used to define what logic is to be executed based on the status of some condition being satisfied. There are two types of conditional statements supported in SQL procedures: CASE. IF.
You should use CASE expression.
Example:
SELECT name,salary,
CASE
WHEN salary <= 2000 THEN 'low'
WHEN salary > 2000 AND salary <= 3000 THEN 'average'
WHEN salary > 3000 THEN 'high'
END AS salary_level
FROM employees
ORDER BY salary ASC
And in this way you should adapt your query to match your needs.
128
Could you use a CASE WHEN control. Take a look at: http://dev.mysql.com/doc/refman/4.1/pt/control-flow-functions.html
27
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With
