VENDORERRORCODE |
207 |
SQLSTATE |
42S22 |
SQL |
SELECT distinct
a.LONGITUDE,
a.LATITUDE,
a.streetNum + ' ' + Streetname address,
a.CITY,
a.state,
a.zip zip_code,
b.phone,
b.schoolID,
b.school_name campus_name,
b.logo,
d.campus_name_long,
d.campusID
FROM
dbo.location a,
dbo.class_schedule c,
dbo.school_lookup b,
dbo.campus_lookup d
WHERE
a.Longitude is not null
and a.LID = c.LID
and c.campusID = d.campusID
and d.schoolID = b.schoolID
and c.status = 'O'
and c.start_date >= getdate() and (c.custom_address is null or c.custom_address = '')
and a.status = 1
and b.status = 1
and b.association_id = 1
and
a.schoolID = '38'
order by
a.LONGITUDE,
a.LATITUDE
|
DATASOURCE |
edudb |
|