×
INTELLIGENT WORK FORUMS
FOR COMPUTER PROFESSIONALS

Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!
  • Students Click Here

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here

Jobs

JOIN without ON

JOIN without ON

JOIN without ON

(OP)
My goal is to update only more recent records into a table from another 'import' table which gets updated daily...

There is considerable 'overlap' and I want to look at the MAX() value of a date in the table to be updated in order to select the records from the import table to be imported.

I came up with this:

CODE

SELECT * from ct_adp_load as new 
JOIN camp_ct_fsc as existing
WHERE new.deldate > MAX(existing.deldate) 
But I get an illegal use of group function error...

What am I doing wrong?

TIA,

-A

RE: JOIN without ON

is this what you were intending?

CODE

select a.* from a.ct_adp_load
where a.deldate > (select max(b.deldate) from camp_ct_fsc) b 

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members!

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close