Featured post

c# - Usage of Server Side Controls in MVC Frame work -

i using asp.net 4.0 , mvc 2.0 web application. project requiremrnt have use server side control in application not possibl in noraml case. ideally want use adrotator control , datalist control. i saw few samples , references in codepleax mvc controllib howwver found less useful. can tell how utilize theese controls in asp.net application along mvc. note: please provide functionalities related adrotator , datalist controls not equivalent functionalities thanks in advace. mvc pages not use normal .net solution makes use of normal .net components impossible. a normal .net page use event driven solution call different methods service side mvc use actions , view completly different way handle things. also, mvc not use viewstate normal .net controlls require. found article discussing mixing of normal .net , mvc.

sql - Query Join Condition -


i have 2 tables named account , assignedgroup. in account table there 2 columns named id , sourceaccount , in assignedgroup have 2 columns named id , assignedgroup.

i want select id joining account , assignedgroup tables. did this:

select a.id account    left outer join assignedgroup b     on a.sourceaccount = b.assignedgorup 

but null output reason being values in sourceaccount this

sourceaccount:

sample sample 

and whereas values in assignedgroup this

assignedgroup:

sample-l1 sample-p-l1 

can me on how join these 2 tables?

i want id's whenever there sample value in both sourceaccount , assignedgroup.

it comparing sample sample-l1 since not equal returning null want id if has values that. mean if somepart of column values matches want values displayed

select  a.id    account left join         assignedgroup b on      b.assignedgorup a.sourceaccount + '-%' 

Comments

Popular posts from this blog

c# - Usage of Server Side Controls in MVC Frame work -

cocoa - Nesting arrays into NSDictionary object (Objective-C) -

ios - Very simple iPhone App crashes on UILabel settext -