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
