i'm making a mysql call from c# to a mysql database for a windows
application.  when i try to use the join command it works fine until the
column being joined gets to a null character and then the rest of that column
becomes null.  my statement is:

"select customers.name, customers.firstname, customers.customerid,  
customers.contact, customers.memorec, extinfo.info, memos.memo from customers
left join extinfo on customers.rec=extinfo.rec left join memos ON
customers.memorec=memos.rec  where customers.rec=extinfo.linkrec and
extinfo.identifier=1 and extinfo.primarytype=2 and customers.inactive=0 order
by customers.name asc"

the info column from extinfo never has a problem, but as soon as a memos.rec
= null or 0 then the rest of the memo field becomes null.  i have tried this
same call in mysql and it works fine, but when i transfer it over to C# it
doesn't work right.  any body know why?  if i do a right join all the memos
show up with their customers, but i need to be able to get all the customers
and memos for the ones that have them.

thanx in advance