I have found my answer.. Many thanks

That is great.. Many thanks...

What would be the syntax if I have 3 or more selects to join ?

Thanks everyone.. I was putting the AND tablename = 'SALE' in a where clause instead of in the ON clause..

Hi Drew,

Your suggestion worked. My final query looks like this:

select s.id, s.people, s.amount, s.ref, m.recordid, m.tablename, m.txt

from sale as s

left outer join usermemo as m

on s.id = m.recordid and...

I've tried adding

and Tablename = 'SALE' in my query but if a sale does not have a memo, it will disregard the sale alltogether

Thanks for your help though

Thanks...

Hi Grasshopper,

Yes, your little modification to the script makes the script work..  Can you explain the logic behind using the square brackets around the field name to make it work??

Thank...

sorry I meant it would not select my sale 176 which has no memo

Unfortunately no since it would not select my sale.id 175 which has no memo.

Thanks..

Hi,

It seems I have a problems with strings and quotes.. I need to create this statement as an Dynamics SQL and I cannot get the quotes right

insert into itemcode1(itemtype,...

Thanks for all your replies..

I'm importing data in an application and the time and date resides in 2 different columns...

Can I use an insert select if I need to transform data

Here is my Insert statement:

create procedure InsertItemType (@itemtype varchar(20), @parkID char(2)) as

declare @NewItemType varchar(20)

set @NewItemType = @ParkID + @ItemType

insert...

Can you explain?

Thanks

Thanks.. it works.. I will now check your links...

Thanks!!  I will try your ideas...