[thelist] SQL Help Please

Rob Smith rob.smith at lexjet.com
Thu Jan 12 12:05:45 CST 2006



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
rob.smith at lexjet.com
(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)

More information about the thelist mailing list