[thelist] SQL Help Please

[Rob Smith]

Hi,

 

I've got two views. They are identical except that the latter view is a
subset of the first one that finds specific criteria. For example,

 

View A: 2 Customers

View B: 1 Customer

 

Ok. Simply put, I want to join the views and get both those numbers in
the same record. Sounds easy right? 

 

But as you can see here: http://www.lexjet.com/lexjet/rob/two_views.jpg
something's not right. In the query results, A is View A. I should have
2 customers. However in B, B is only supposed to have 1. I'm I joining
something wrong?


Rob Smith
LexJet
rob.smith at lexjet.com
http://www.lexjet.com
(800)453-9538
(941)330-1210 Int'l
(941)330-1220 Fax
1680 Fruitville Road, 3rd Floor
Sarasota, FL 34236

Proud Sponsors of the Professional Digital Imaging Association (www.pdia.org)