I wanted to write the following multi-statement SQL query. It needs to do the following.

1. DO a search
2. If no search results then insert (create ID)
3. Redo the search
4. IF ID not found n the search then delete record with the ID

Does anyone have any pseudocode suggestions for mySQL

Deco

#############################################################

This message is sent to you because you are subscribed to
the mailing list Lasso Lasso@lists.lassosoft.com
Official list archives available at http://www.lassotalk.com
To unsubscribe, E-mail to: <Lasso-unsubscribe@lists.lassosoft.com>
Send administrative queries to <Lasso-request@lists.lassosoft.com>