----------------------------------------------------------- New Message on BDOTNET
----------------------------------------------------------- From: karunreddi Message 13 in Discussion If you dont have any relation with the table its come under outer join that returns all the values from both the table depending on the need go for either left outer or right outer Rgds Karun -----Original Message----- From: BalajiKrishnan [mailto:[EMAIL PROTECTED] Sent: Wednesday, January 07, 2004 11:34 AM To: BDOTNET Subject: SQL QUERY - DOUBT .!!!!!!!!!!!!!!!!!!!!!!!! New Message on BDOTNET SQL QUERY - DOUBT .!!!!!!!!!!!!!!!!!!!!!!!! Reply Reply to Sender Recommend Message 1 in Discussion From: BalajiKrishnan Hi ALL, I have two tables... Table 1 : Information name address city state A XYZ MNO PQR Only one row in the table. Table 2 : TblDetails F1 F2 F3 F4 F5 12334 A B C 2001 444 X Y Z 2002 This table will have multiple rows So now i need to select Information.name,Information.Address,TblDetails.F1, TblDetails F2,TblDetails F3 WHERE TblDetails F5 = <CONDITION> i dont have any common fields inbetween these tables. How can i get it in a single query. Balaji View other groups in this category. DISCLAIMER: This message (including attachment if any) is confidential and may be privileged. Before opening attachments please check them for viruses and defects. MindTree Consulting Private Limited (MindTree) will not be responsible for any viruses or defects or any forwarded attachments emanating either from within MindTree or outside. If you have received this message by mistake please notify the sender by return e-mail and delete this message from your system. Any unauthorized use or dissemination of this message in whole or in part is strictly prohibited. Please note that e-mails are susceptible to change and MindTree shall not be liable for any improper, untimely or incomplete transmission. ----------------------------------------------------------- To stop getting this e-mail, or change how often it arrives, go to your E-mail Settings. http://groups.msn.com/bdotnet/_emailsettings.msnw Need help? If you've forgotten your password, please go to Passport Member Services. http://groups.msn.com/_passportredir.msnw?ppmprop=help For other questions or feedback, go to our Contact Us page. http://groups.msn.com/contact If you do not want to receive future e-mail from this MSN group, or if you received this message by mistake, please click the "Remove" link below. On the pre-addressed e-mail message that opens, simply click "Send". Your e-mail address will be deleted from this group's mailing list. mailto:[EMAIL PROTECTED]
