Groups > comp.databases.ms-sqlserver > #798

comparing two table

From	John Kim <jinumarketing@gmail.com>
Newsgroups	comp.databases.ms-sqlserver
Subject	comparing two table
Date	2011-11-11 04:11 -0800
Organization	http://groups.google.com
Message-ID	<2ddbf504-fed9-415e-ac73-8a2839ea0588@w20g2000prc.googlegroups.com> (permalink)

Show all headers | View raw

i have two tables.

one table - tbl_attempted issue has number field with the following
values.


number field record values - 1, 3, 4, 5


the other table - tbl_issues_out has another number field with the
following value.


number field record value - 7


IS THERE A WAY TO CHECK THESE TWO TABLES and come up with values,


2, 6


??


the other table with value 7 is the issues sent out so far, and the
first table is attempted issue so far.


since issue 1, 3, 4, 5 and attempted, and up to issue 7 are sent
out..


SQL code should compare 7 against 1, 3, 4, 5 and come up with 2, 6.


CAN ANY BODY HELP ME WITH SQL CODE TO DO THIS??

Back to comp.databases.ms-sqlserver | Previous | Next — Next in thread | Find similar

Thread

comparing two table John Kim <jinumarketing@gmail.com> - 2011-11-11 04:11 -0800
  Re: comparing two table "Andrew Morton" <akm@in-press.co.uk.invalid> - 2011-11-11 13:01 +0000
  Re: comparing two table Erland Sommarskog <esquel@sommarskog.se> - 2011-11-11 23:40 +0100

csiph-web