Need help querying two tables sometimes

• Orblin McLoon

  SSC Veteran

  Points: 256

  More actions

  September 14, 2005 at 8:40 am

  #165482

  Hi. I need to run a query that gets info from one table, and then if a certain field is equal to a certain value, get something from another table.

  Here's the example, from table 'Account' I select

  Name, Email, Accountlevel

  Then, IF accountlevel is 10, get the value 'PhoneNumber' from table 'AdminInfo'.

  Is this doable in one statement?

  Thanks.

   

• Ninja's_RGR'us

  SSC Guru

  Points: 294069

  More actions

  September 14, 2005 at 8:48 am

  #589739

  Just do the select like if you wanted to always get that phone number. Then write this :

  CASE when accountlevel = 10 THEN AdminInfo.PhoneNumber ELSE 'Another field, or null..' END as PhoneNumber

• David A. Long

  SSCrazy Eights

  Points: 8421

  More actions

  September 14, 2005 at 11:29 pm

  #590005

  Try:

  SELECT A.Name, A.Email, A.Accountlevel, I.PhoneNumber

  FROM Account AS A

   LEFT JOIN AdminInfo AS I ON A.<your linking field> = I.<your linking field>

    AND A.AccountLevel = 10

  Andy