General information
Category:
Coding, syntax & commands
Title:
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!
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only