seems simple what am i missing?

[dflow]

i want a list of the event type name where there are records with content

 

SELECT DISTINCT event_types.EventType
FROM city_events, event_types
WHERE city_events.Event_Content <> ''
AND city_events.CityID =100
ORDER BY event_types.EventLevel ASC
LIMIT 0 , 30

[ManiacDan]

You don't join the two tables.

 

-Dan

[dflow]

ok one of these days

 

forgetting stuff thanks

 

SELECT DISTINCT event_types.EventType
FROM city_events, event_types
WHERE city_events.Event_Content <> ''
AND city_events.CityID =100
AND event_types.Event_TypeID = city_events.Event_TypeID
ORDER BY event_types.EventLevel ASC
LIMIT 0 , 30