sqlplus - sql multiple attribute join -

-

i'm creating test database on medical practices. here picture of er diagram reference. er diagram

so question how joins properly. i'm trying give list of patients seen given practice (e.g practice id 1) want show practice name , details. want show list of patients , and gp's work or have been practice (keep in mind have populated tables 10 rows of test data)

i have got far 

select patient.firstname, patient.surname patient join appointment on patient.patientid = appointment.patientid appointment.practiceid in (1) order firstname;

`how include practice details , gp details associated practice. what's confusing me how add more select statements if not patient table. great!

you can add more join clauses:

select   patient.firstname, patient.surname, practice.name, practice.address     patient join     appointment on patient.patientid = appointment.patientid join     practice on appointment.practiceid = practice.practiceid    appointment.practiceid in (1) order firstname;

Comments

Post a Comment

Popular posts from this blog

Django REST Framework perform_create: You cannot call `.save()` after accessing `serializer.data` -

-
i have following viewset: class artistprofileviewset(viewsets.modelviewset): queryset = artistprofile.objects.all() serializer_class = artistprofileserializer def perform_create(self, serializer): if serializer.is_valid(): serializer.save() with following serializers: class simpleartisttrackserializer(serializers.hyperlinkedmodelserializer): class meta: model = artisttrack fields = (...my fields...) class artistprofileserializer(serializers.hyperlinkedmodelserializer): owners = userserializer(many=true, required=false) tracks = simpleartisttrackserializer(many=true, required=false) class meta: model = artistprofile fields = (...my fields...) i getting following error: assertionerror: cannot call `.save()` after accessing `serializer.data`.if need access data before committing database inspect 'serializer.validated_data' instead. i don't see editing serializer.data object. th...
Read more

Why does Go error when trying to marshal this JSON? -

-
i'm trying rather simple example of trying decode json file structs using golang. however, when attempting error that json: cannot unmarshal object go value of type []main.track which don't understand. here's code in question, , json can found here . package main import ( "encoding/json" "fmt" "net/http" "os" ) // tracks group of track types type tracks struct { tracks []track } // track represents singular track type track struct { name string url string artist artist } // artist represents single artist type artist struct { name string mbid string url string } func main() { url := "http://ws.audioscrobbler.com/2.0/?method=geo.gettoptracks&api_key=c1572082105bd40d247836b5c1819623&format=json&country=netherlands" response, err := http.get(url) if err != nil { fmt.printf("%s\n", err) os.exit(1) } de...
Read more