Thanks Sergiy

That works really well.  Appreciate the help and time.

Regards, Alison

Well, I like the page peel ad - it's pretty easy to ignore if you don't want to view it and when you do, it's quite a nice dynamic ad...

Thanks for that.  Got it working so that it returns Billie

Didn't realise you could use joined tables in the where clause, thought...

Hi

I just recently had to work this out (moving website from MySQL to MS SQL and missing the last_insert_id ).

I found this worked:

SET...

Hi (me again )

I thought maybe I'd better explain how I'm imagining my query to work:

Select from property where

(if buyer_id is not null join...