Thanks for the reply.

That gives me something to work with; I would have never have considered doing a 'double' join on the same table.

Thanks again, it's much appreciated.

Hmmn, that sort of works, but what I'm after is this results wise:

doctorname doctorlocation drugname packsize count Total Drugs Prescribed

Campbell ...

Our dba is away on long term sick at the moment and this has fallen to me ('the network guy') to sort out as I've used SQL "once or twice"....

Thank you both for your help, it's much appreciated.

I see what I was doing wrong now, by not using the dpd table as the main 'from' table in the query.

Thanks...

Further to this, I wonder if you could help me out with a query that uses these tables;

Create table drugs

(

drugref varchar (5),

name varchar(120),

DosageMG varchar(120),

PackSize int

)

GO

INSERT INTO Drugs

SELECT 'A1', 'Aspirin', '75',...

@ Jeff Moden: Thanks for the response; Sorry about not posting correctly :blush: I'll get it right next time. Thanks for your help, it's much appreciated.

@ kapil_kk: Thanks for the...