sql server - complex sql query many to many -

-

i've been created database that:

my database diagram

i want select person , movie names same person act "oyuncu" , "senarist"

please me. wrote query that;

select      moviename,personname,rolename       movies,     moviespersonrole,     personrole,     person,     role      movies.id = moviespersonrole.movieid      ,      personrole.id = moviespersonrole.personroleid      ,      personrole.roleid = role.id      ,      personrole.personid = person.id

and results are

moviename         personname    rolename pulp fiction       mehmet        oyuncu pulp fiction       mehmet        senarist matrix             aylin         oyuncu lotr               gökberk       oyuncu lotr               gökberk       senarist pulp fiction       aylin         oyuncu

you can try somethong this:

select x.moviename, x.personname (   select m.moviename, pe.personname, count(*) rolecount     movies m     inner join moviespersonrole mpr on (mpr.movieid=m.id)     inner join personrole pr on (pr.id = mpr.personroleid)     inner join person pe on (pe.id = pr.personid)     inner join role r on (r.id = pr.roleid)     r.rolename='oyuncu' or r.rolename='senarist'      group m.moviename, pe.personname   ) x x.rolecount>1

Comments

Post a Comment

Popular posts from this blog

Android : Making Listview full screen -

-
<linearlayout xmlns:android="http://schemas.android.com/apk/res/android" xmlns:tools="http://schemas.android.com/tools" android:layout_width="match_parent" android:layout_height="match_parent" android:orientation="vertical" tools:context=".mainactivity"> <edittext android:layout_margintop="5dp" android:layout_width="match_parent" android:layout_height="50dp" android:background="@drawable/location_edittext" android:id="@+id/locationeditext" android:textsize="15sp" android:textcolor="#999" android:paddingleft="15dp" /> <com.example.ravi_gupta.slider.viewpagercustomduration android:layout_width="wrap_content" android:layout_height="0dp" android:id="@+id/viewpager" android:scrollbarstyle="outsideoverlay" android:layout_weight="0.5...
Read more

javascript - Parse JSON from the body of the POST -

-
i'm using cameratag.com record video on website. service can send json response server can save data database. don't know how proceed here: the documentation states please note json repsonse passed in body of post , not form parameters. here example of how parse response in ruby: data = json.parse(request.raw_post) video_uuid = data["uuid"] but don't know how data on javascript. i'm not experienced in js please bare me :) post sample: { "uuid": "00012710-4b65-0131-ffe6-22000a499ea4", "camera_uuid": "98373a20-79ee-0130-3e42-1231390fcc11", "created_at": "2013-12-20t05:25:02.000z", "percent_complete": 100, "short_code": "kktb4q", "metadata": { }, "state": "published", "recorded_from": "http://singwho.com", "publish_type": null, "formats": [ { "name...
Read more

javascript - How to Hide Date Menu from Datepicker in yii2 -

-
basically in datetimepicker widget date choose first time, how can hide date option widget , filter according time. tried not working want hide remove button [ 'attribute'=>'time', 'label'=>'time', 'format'=>'raw', 'value'=>function($data){ return date('h:i:s',strtotime($data->time)); }, 'filter'=> datetimepicker::widget([ 'model' => $searchmodel, 'attribute' => 'time', 'clientoptions' => [ 'autoclose' => true, 'format' => 'hh:ii', 'showon' =...
Read more