Not sure of your exact question.
Do you just want to find Bid_Code and Bid_Item (s) that are not in [Bid
Table]?
If so, a simple way is to just use NOT IN:
Select
*
from
[Bid Table]
Where
Bid_Code NOT IN (Select distinct Bid_Code From [BidtoPO Table])
AND
Bid_Item NOT IN (Select distinct Bid_Item From [BidtoPO Table])
Or you could cancat the two:
Select
*
from
[Bid Table]
Where
UPPER(cast(Bid_Code as varchar) + cast(Bid_Item as varchar)) NOT IN
(select distinct(UPPER(cast(Bid_Code as varchar) + cast(Bid_Item as
varchar))) from [BidtoPO Table])
I just typed this free-hand so may have some errors.
If this is not what your were looking for let me know.
On Fri, Oct 24, 2008 at 11:41 AM, iwasinnihon <[EMAIL PROTECTED]> wrote:
>
> I am designing a report in Crystal Reports. I am fairly new to the
> software. I have a database that tracks purchases made, including
> requisitions, bids, and purchase orders. I am creating a report that
> will list the bids that are not awarded. The easiest way I can see to
> do it is to compare two tables and have it list where the bid and line
> item are listed in one table, but not the other. However, I am at a
> loss as how to do this. The tables and fields are listed below
>
> Bid Table
> Bid_Code
> Bid_Item
>
> BidtoPO Table
> Bid_Code
> Bid_Item
>
> If both the code and item is listed, it should not be listed in the
> report. How do I do this?
>
> >
>
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups
"DotNetDevelopment, VB.NET, C# .NET, ADO.NET, ASP.NET, XML, XML Web
Services,.NET Remoting" group.
To post to this group, send email to [email protected]
To unsubscribe from this group, send email to [EMAIL PROTECTED]
For more options, visit this group at
http://groups.google.com/group/DotNetDevelopment
You may subscribe to group Feeds using a RSS Feed Reader to stay upto date
using following url
<a href="http://feeds.feedburner.com/DotNetDevelopment";>
http://feeds.feedburner.com/DotNetDevelopment</a>
-~----------~----~----~----~------~----~------~--~---
