SQL Query help

Im trying to create an SQL query but get the following error

Can anyone please help ?

All I want to do is display the name of everything where the parent is named "01 - PRIME Wave 1"

if anyone can also tell me how I do it for several parents also would be good

Thanks

Maybe I am getting old, but I had some trouble reading that. Could you post the text from the error into the thread?

Upload the image to an externale image host, as unfortunatly the image size guidelines here are awfully stupid. :george:

http://imageshack.us

:)

Assuming you are using MS SQLServer (image not clear), change the SQL to use single quotes.

e.g.

Select NameColumn from MetaTable where NameColumn = '01 - PRIME Wave 1'