Thanks. I used

SELECT*

FROM@t1 AS t1

right JOIN@t2 AS t2 ON t2.i = t1.i or (t2.i is null and t1.i is null)

it worked great.

That's working now, thanks very much!

Here's my code:

INSERT INTO tblRegistrations (r.academic_year, r.faculty_code, r.faculty_description, r.department_code, r.department_description,

r.course_level, r.location_code, r.location_description, r.franchised,

r.funding_type, r.Residential_Status, r.residential_status_description, r.Course_Code, r.mode_of_study)

SELECT (c.academic_year, c.faculty, c.faculty_description, c.department_code, c.department_description, c.course_level_code,

c.location_of_study, c.location_of_study_description,...

thanks, I can't quite get it to work, the only thing I can think of is that the columns have slightly different names in the two tables, would that be...

not quite, I want to find all the records that exist in both tblstudent_course and tblNew_entrants. I then want to see if any of that set appear in tblRegistrations....

I need to find all the records that exist in tblStudent_course and tblNew_entrants and then find if they exist in tblRegistrations, any that are not already in tblRegistrations need to...

Will do! Thanks again.

Thanks Chris, that's working fine!

Hi All

thanks for your replies.  I've actually done the formatting in my code now as what I was putting into the SQL query was not affecting what showed up on...

Hi Adrian

They're both datatype money anyway, so maybe I don't need to do the cast at all.  I did try taking that out of the sql statment and just had:

tblInventoryItem.itemcost as...

I'm nearly there, but I haven't quite managed to get it working.  I've got it checking the timestamp and that all works correctly.  When there has been an update by...

Here's the link.....

http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=72845

Thanks that's helpful.  I'm not sure that I can use it in my application though because I do not always know how many authors there are for each book, so...

Thanks for your replies, I tried Ken's query in the Query analyzer and got the following error msg: "The column prefix 'P2' does not match with a table name or alias...

Thanks, that's working fine now.