Database

select  p_id, 
        p_name, 
        p_path,
        case when uw.username is not null then uw.username 
             when um.username is not null then um.username 
             else null
        end creator,
        uw.username,
        um.username
from    pics
left join usersmobile um
    on  pics.p_userId_mobile = um.p_userId_mobile
left join  UsersWWW uw
    on  pics.p_userId_www = uw.p_userId_www

Image
  imageid PK
  name
  path

users /*only one usertable*/
  userid PK
  username

accesstype
  accesstypeid PK
  accesstype  /*www and mobile*/

useraccess
  useraccessid PK
  userid       FK
  accesstypeid FK

unique key (userid,accesstypeid)

imagecreated
  imagecreatedid PK
  imageid        FK
  useraccessid   FK
  createdate

unique key (imageid,useraccessid) /*an image can only be created once*/

imagechanged
  imagechangedid PK
  imageid        FK
  useraccessid   FK
  changedate

andreas.schaerer wrote:

that triggers would do the job just fine

netJP12L wrote:

First name is John and there is no last name then upon concatanting both names i get null.

netJP12L wrote:

I have set the database "Concatenate Null yeilds Null" to True

poornas wrote:

hope you understood my requirement.

SELECT DR.id,
	SUM(case PC.id when 4 then amount else 0 end) AS PCID4,
	SUM(case PC.id when 5 then amount else 0 end) AS PCID5,
	SUM(case PC.id when 3 then amount else 0 end) AS PCID3,
	SUM(case PC.id when 6 then amount else 0 end) AS PCID6,
	SUM(case when pc.id = 2 and DP.id = 211 then amount else 0 end) AS DPID211,
	SUM(case when pc.id = 2 and DP.id = 210 then amount else 0 end) AS DPID210,
	SUM(case when pc.id = 2 and DP.id = 212 then amount else 0 end) AS DPID212,
	SUM(case when pc.id = 2 and DP.id = 213 then amount else 0 end) AS DPID213,
	SUM(case when pc.id = 2 and DP.id = 214 then amount else 0 end) AS DPID214,
	SUM(case when pc.id = 2 and DP.id = 197 then amount else 0 end) AS DPID197,
	SUM(case when PC.id = 1 and DP.id3 = 45 then amount else 0 end) AS DPID45
FROM
	table1 DR
	LEFT JOIN table2 DP 
		ON DP.id1 = DR.id1
	LEFT JOIN table3 PL 
		ON DP.id2 = PL.id
	LEFT JOIN table4 PC 
		ON PL.id1 = PC.id
WHERE
	DR.date = GETDATE()
group by
	DR.id

if a = 1 then
 "abc"
else if a = 2 then
 "222"
else
 "222"