‘41’ institution_code,
c.ssn,
c.last_name,
c.first_name,
c.middle_initial,
k.annual_sch_completed,
y.fafsa_received,
y.cost_of_education,
w.tuition,
y.fee_residence,
v.room_board_charges,
x.other_charges,
y.dependency_status,
y.parent_contribution,
y.student_contribution,
y.parent_income,
y.student_income,
max(decode(z.seq, 2, z.fund || ’ ’ || z.amount, null)) fund2,
max(decode(z.seq, 4, z.fund || ’ ’ || z.amount, null)) fund4,
max(decode(z.seq, 6, z.fund || ’ ’ || z.amount, null)) fund6,
max(decode(z.seq, 8, z.fund || ’ ’ || z.amount, null)) fund8,
max(decode(z.seq, 10, z.fund || ’ ’ || z.amount, null)) fund10,
max(decode(z.seq, 12, z.fund || ’ ’ || z.amount, null)) fund12
inner
Hi all,
I have this SQL statement below. It throws an error saying “FROM not found where expected.” If the script below is too messy. I have attach a txt file of the script.
Please enlighten me why it would do throw an error.
KEVIN
select distinct c.pidm_key,‘2010’ finaid_year_begin,‘C’ commuter_status,‘0’ annual_contact_hrs_completed,max(decode(z.seq, 1, z.fund || ’ ’ || z.amount, null)) fund1,max(decode(z.seq, 3, z.fund || ’ ’ || z.amount, null)) fund3,max(decode(z.seq, 5, z.fund || ’ ’ || z.amount, null)) fund5,max(decode(z.seq, 7, z.fund || ’ ’ || z.amount, null)) fund7,max(decode(z.seq, 9, z.fund || ’ ’ || z.amount, null)) fund9,max(decode(z.seq, 11, z.fund || ’ ’ || z.amount, null)) fund11,from as_student_enrollment_summary c
TOAD FORUM.txt (5.49 KB)