Hey all, I have three tables for an office mgmt app that I am running: SSL_info ---------- SSL_ID (PK) SSL_domain_FK SSL_renew_date SSL_vendor ...etc
...and... domains ---------- domain_ID (PK) domain_company_FK domain_name ...etc ...and... companies ------------ company_ID (PK) company_name company_address ...etc I need to get a query that, provided the company_ID, will capture all the domains associated with the company, as well as those domains that have SSL info. Can anyone help? Here is what I have, but I know this is not correct: SELECT * FROM domains, SSL_info WHERE domain_company_FK = #company_ID# AND SSL_domain_FK = domain_ID I know why I am getting zero records returned, but I don't know how to get what I want... Thanks, Ray ============================================= Ray Champagne - Senior Application Developer CrystalVision Web Site Design and Internet Services 603.433.9559 www.crystalvision.org ============================================= The information contained in this transmission (including any attached files) is CONFIDENTIAL and is intended only for the person(s) named above. If you received this transmission in error, please delete it from your system and notify us immediately. If you are not an intended recipient, please note that any use or dissemination of the information contained in this transmission (including any attached files) and the copying, printing, or retransmission of that information is strictly prohibited. You can notify us by return email or by phone at 603.433.9559. Thank you. ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net http://www.cfhosting.net Message: http://www.houseoffusion.com/lists.cfm/link=i:4:184658 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
