What you are looking for is called an outer join Left or Right * and an = Left outer join *= Right outer join =*
The Left Join will fill in nulls in the right table that don't have representative link in the left table. Change the join operator from = to *= (left outer) Ben Johansen - http://www.pcforge.com Authorized Witango Reseller http://www.pcforge.com/WitangoGoodies.htm Authorized MDaemon Mail Server Reseller http://www.pcforge.com/AltN.htm -----Original Message----- From: Dan Stein [mailto:[EMAIL PROTECTED] Sent: Friday, March 07, 2003 1:32 PM To: [EMAIL PROTECTED] Subject: Witango-Talk: Join Question In a search action join Table A has multiple records with Student_ID but in some cases it is null because of legacy issues I am joining to a table that contains unique student_Id so I can pull back the name But I want a record even if the value in Table A is null because the rest of the values are still important. So how do I do the join so the search does not fail because there is a null value for student_ID in table A. The other possibility is that I could set the Student_Id in table A equal to the student_ID in another table where the reg_iD in Table A = the reg_ID in table B ( this will give me the billing name student_ID which is not completely accurate but will still server the purpose and will eliminate the nulls) Only problem is last time I tried this I messed up the SQL statement and ended up with all the records changed and the ID's messed up. Dan -- Dan Stein Digital Software Solutions 799 Evergreen Circle Telford PA 18969 Land: 215-799-0192 Mobile: 610-256-2843 Fax 413-410-9682 FMP, WiTango, EDI,SQL 2000 [EMAIL PROTECTED] www.dss-db.com ________________________________________________________________________ TO UNSUBSCRIBE: send a plain text/US ASCII email to [EMAIL PROTECTED] with unsubscribe witango-talk in the message body ________________________________________________________________________ TO UNSUBSCRIBE: send a plain text/US ASCII email to [EMAIL PROTECTED] with unsubscribe witango-talk in the message body
