Information générale
Catégorie:
Codage, syntaxe et commandes
Titre:
More Problems with sql select statements with multiple table
Hello:
THanks for those that previously responded to my sql problem but
I'm still having trouble getting the results I need from my three tables.
I need to print to a report the client information for the client table based on o the result on a match on sins in act_plan table and the coun_sum table that match a sin in the client table where the field follow_dte isn't empty in the action plan table and that a value exists in the casemang or nddetby in the coun_sum table. I have the following code that isn't working.
select distinct client.sin, allt(client.surname) + "' " + allt(client.firstname) as fullname, client.phone1; from act_plan ap INNER JOIN coun_sum cs on ap.sin = cs.sin INNER JOIN client where
!empty(cs.casemang) or !empty(cs.nddetby)INNER JOIN CLient on ap.sin = client.sin where !empty(ap.follow_dte); order by client.sin into cursor repdata
Any assistance would be greatly appreciated! Thanks so much!
Suivant
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement