Thanks John,

That makes sense! Do you see anyway around this with that code? This stuff is all new to me so i'm not an expert.

Many thanks.

Ahhh, the times were impacting it! Thank you for the help.

Hi again,

Thank you for your detailed reply Luis Cazares I have only just seen your reply, I am going to read the article. I must confess I was a bit...

Hi Luis Cazares,

Could I just pick your brains please. Option 2 seems to be working great but I would like to change the table reference form wce_bookings to wce_quotes. I...

Hi Luis Cazares,

Could I just pick your brains please. Option 2 seems to be working great but I would like to change the table reference form wce_bookings to wce_quotes. I...

Hi Luis Cazares,

Could I just pick your brains please. Option 2 seems to be working great but I would like to change the table reference form wce_bookings to wce_quotes. I...

Firstly, thank you both for all that input. Lots to think about and play with.

Luis Cazares - those two options are great, I think i can use those to achieve...

Thanks pietlinden for your reply too. I don't have a calendar table. Is this something that is a standard SQL table structure I copy then use with your query? Thanks...

Hi Thanks for your reply. All those dates are bookings. So each row equates to a booking with an arrival and departure date. Is that what you meant?

Thanks again.

Thanks Hugo really appreciate your help. That has resolved my issue and I get the logic now. Also picked up lots of important things there for future reference. Thanks again.

Thank you Hugo, very detailed reply, I need to go through this in more detail and test your suggestions. Sorry for too much sample data but I thought you should...

Thanks for the replies. Here is the script for the tables /data. I also revised the queries as i made alterations to the tables. Thanks for your help.

This query shows...

HI,

Here is the answer to my question, this query gets the results.

Select * from history h where not exists(select 1 from linkto where lutablename = 'history' and letablename =...

Thanks for the reply John,

I am tryin gthe insert part of what you suggested but no matter where i put it i get, loads of erros. Here is the code...

Hi Cadavre,

Is there any chance you could help me out with getting your example to insert into a psychical table called table2 with an id column and a column called...