Home » SQL & PL/SQL » SQL & PL/SQL » Compare sequences in two tables to find missing sequence no
Compare sequences in two tables to find missing sequence no [message #190210] Tue, 29 August 2006 13:21 Go to next message
coolguy01
Messages: 64
Registered: August 2006
Member
hey i have two tables with a similar type of column that conatin some sequence numbers. The second table is actually a table which conatins the missing sequence nos in the first table. Even then there may still be some more nos in the sequence missing..... so how do i compare both the tables to find the missing sequence nos or rows from both the table?? how do i compare the two tables??
Re: Compare sequences in two tables to find missing sequence no [message #190219 is a reply to message #190210] Tue, 29 August 2006 15:01 Go to previous message
joy_division
Messages: 4768
Registered: February 2005
Location: East Coast USA
Senior Member
Whoops, I misread this duplicate post.

[Updated on: Tue, 29 August 2006 15:19]

Report message to a moderator

Previous Topic: Compare sequences in two tables to find missing sequence no
Next Topic: What is the best way to do this???
Goto Forum:
  


Current Time: Wed Aug 23 16:38:16 CDT 2017

Total time taken to generate the page: 0.10019 seconds