Thanks for you help and time, yes I see that now!!! I had my query wrong, guess we could have done better on that product, to avoid 2 customer...

Thanks, the in clause looks much better I had removed all the brackets from the where but the gui outs them back in.

Looking at it I have removed the group...

It works!! spent a couple of days reading articles on using the select in the from and join part of the query when I see it with my tables it...

Thanks andy, just working through it now but it looks pretty Good!!!!:-)

I have had a reread!!!

The way explained seems alot better than what I was tying to do.

I think this file ticks all the boxes, creates a db, creates tables...

Hi

I have created a sql script that creates a test db and 3 tables it imports 2 of the tables ok, but I have tried all day on the...

Ok, thanks 🙂

I have attached 4 files the one called tables has the code to create the tables, and the files called examples have test data for the tables.

If...

Thanks for the quick reply, sorry for the format!!!!!

I have been dropping such queries into tmp tables for ages!!!!!!

Something learnt there!!!