Sorry to be a nuisance again but could any of you show me how to do a nested query to use a third form normal search? I can do single form but don't know how to nest queries for third form.

Select * from authors where author='jon grisham'

I.e. How do I get the note data from the note table for 'John grisham' into that query as part of the returned data since the note field in aithors is a link to a third normal form?

Yes, I will be able to learn from the wise masters:):)