Ian, I'd just pulled up SQL Query analyzer to see if I could get this to work as you replied, but now I'll be checking out the visual wizard as per your advice. I knew it had to with joins, but that was it. Your answer works perfectly btw, much appreciated.
Mark The visual wizard is pretty nice if you don't try to get TOO complex. One can drag the tables then drag the fields for the join then drag them for the select in the "Design View". Once you have it all dialed in and returning the data you expect, then just switch to the "SQL View" and see what it looks like. This helped me a lot when I was trying to figure out LEFT and RIGHT OUTER JOINS with nulls to get all the fields from one table with no matches in another. -------------- Ian Skinner Web Programmer BloodSource www.BloodSource.org Sacramento, CA "C code. C code run. Run code run. Please!" - Cynthia Dunning Confidentiality Notice: This message including any attachments is for the sole use of the intended recipient(s) and may contain confidential and privileged information. Any unauthorized review, use, disclosure or distribution is prohibited. If you are not the intended recipient, please contact the sender and delete any copies of this message. ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Find out how CFTicket can increase your company's customer support efficiency by 100% http://www.houseoffusion.com/banners/view.cfm?bannerid=49 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:224150 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
