G
Guest
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
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