Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Finding Missing Pages

Status
Not open for further replies.
VVVA

VVVA

Technical User
Sep 19, 2006
35
US
If I have these three tables, how can I quickly get a list of missing pages, pages that are in the testbook table, but not in the Pages table, and that are less than the maxpage for that book?

Code: 
Pages
--------------------------
Book    Page
000001  0001
000001  0003
000002  0001
000002  0005

Code: 
Maxpage
--------------------------
Book    Maxpage
000001  0003
000002  0005

Code: 
Testbook
--------------------------
Page
0001
0002
....
9999
 
Sort by date Sort by votes
a simple left join ought to do it...

Known is handfull, Unknown is worldfull
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

NBVC
  • Locked
  • Question
Finding IP address for a linked Oracle server 1
Replies
2
Views
172
NBVC
NBVC
EM1107
  • Locked
  • Question
Find missing level number in dable.
Replies
7
Views
49
Andrzejek
Andrzejek
EM1107
  • Locked
  • Question
Help finding a way to show my information on one row 3
Replies
11
Views
63
dhookom
dhookom
grnzbra
  • Locked
  • Question
Missing Millisecond
Replies
2
Views
49
Olaf Doschke
Olaf Doschke
Auguy
  • Locked
  • Question
Insert Missing GL Periods From One Table To Another
Replies
2
Views
43
Auguy
Auguy

Part and Inventory Search

Sponsor

Back
Top