fixed the issue. Will look into that further What is wrong with this query: , Try this query -
SELECT * FROM families f
JOIN family_histories fh
ON f.id = fh.family_id
f.family_status_cat_id = 1422 AND
fh.created_at BETWEEN '2010-02-13' AND '2013-03-06' AND
fh.family_history_cat_id = 1422 AND
fh.new_value LIKE '%1422%'
angularjs - ng-class - [$parse:syntax] Syntax Error: Token ':' is an unexpected token at column 11 of the expression
wish of those help Adding a column at a specific location is not important because you can easily change the order of displaying in SELECT statement. There is a very useful post by Pinal Dave you can find it here.
Syntax error when assigning column value using CASE WHEN in Computed Column Formula
it should still fix some issue Using COALESCE is better option than ISNULL or CASE..WHEN for this problem since the input values for the COALESCE expression can be evaluated multiple times. You can also use NULLIF to check the conditions in those NULL valued columns.
AngularJS Error: [$parse:syntax] Syntax Error: Token ',' is unexpected, expecting ] at column 92 of the expression