if else cond for select statement

reddy761 · #1 (**permalink**) 10-07-09, 01:31

Hi
I need if else cond for my sql,
I have ACCOUNT is my master table contains account id is the column for comparing for other tables.

I have other two child tables contains account id column in both the tables.

my data will be there in my master table all account id information.
similarly my data will be the in my child tables either one of them either first child table or second child table.

how can i write my sql select query for getting the data by comparing account id

tryign to this way..plz correct me

CASE WHEN(INNER JOIN CRMDETAILS ON CRMDETAILS.ACID = ADVACDETAIL.ACID)
THEN
CRMDETAILS.CRMSECUID AS CRMSECUID,
CRMDETAILS.DTOFISSUE AS DTOFISSUE,
CRMDETAILS.DTOFMATURITY AS DTOFMATURITY,
CRMDETAILS.CURRENTVALUE AS CURRENTVALUE,
ELSE
PRIMARY_SECURITY.CRMSECUID AS CRMSECUID,
PRIMARY_SECURITY.CURRENTVALUE AS CURRENTVALUE,
PRIMARY_SECURITY.DTOFISSUE AS DTOFISSUE,
PRIMARY_SECURITY.DTOFMARTURITY AS CURRENTVALUE

Thanks
Venkatesh

dav1mo · #2 (**permalink**) 10-07-09, 14:19

try looking at union

r937 · #3 (**permalink**) 10-07-09, 17:34

try two LEFT OUTER JOINs

Code:

SELECT COALESCE(crmdetails.crmsecuid   
               ,primary_security.crmsecuid    ) AS crmsecuid        
     , COALESCE(crmdetails.dtofissue        
               ,primary_security.dtofissue    ) AS dtofissue   
     , COALESCE(crmdetails.dtofmaturity     
               ,primary_security.dtofmaturity ) AS dtofmaturity
     , COALESCE(crmdetails.currentvalue     
               ,primary_security.currentvalue ) AS currentvalue
  FROM advacdetail
LEFT OUTER
  JOIN crmdetails 
    ON crmdetails.acid = advacdetail.acid
LEFT OUTER
  JOIN primary_security
    ON primary_security.acid = advacdetail.acid

Internet Services

Web Development

Digital Marketing

Consumer Tech