problem with creating view?
-
Hi, I need help with gridview? actually the gridview is supposed to show a view(aka join) consisting of two tables . In my case I have (userid) , (money deposited) as fields in table 1; userid can also be left as null. I have another table I have first_name, last_name,phone numbers( fields) in table2 I want to display first_ name ,money deposited. in the gridview. It has to show all the enteries made in table 1 either it is null or has some userid; if it becomes null , then a space should appear instead of displaying null. can anyone please guide me how to do this? thanks
-
Hi, I need help with gridview? actually the gridview is supposed to show a view(aka join) consisting of two tables . In my case I have (userid) , (money deposited) as fields in table 1; userid can also be left as null. I have another table I have first_name, last_name,phone numbers( fields) in table2 I want to display first_ name ,money deposited. in the gridview. It has to show all the enteries made in table 1 either it is null or has some userid; if it becomes null , then a space should appear instead of displaying null. can anyone please guide me how to do this? thanks
try something like this - I have to assume that userid appears in table3 also, therwise this is no way to join them select isnull(first_name,' '), [money deposited] from table1 t1 left outer join table2 t2 on t2.userid = t1.userid
Bob Ashfield Consultants Ltd Proud to be a 2009 Code Project MVP