Thread: Query with case
View Single Post
  #6 (permalink)  
Old August 23rd, 2012, 12:12 PM
prgcode prgcode is offline
Registered User
Points: 3, Level: 1
Points: 3, Level: 1 Points: 3, Level: 1 Points: 3, Level: 1
Activity: 0%
Activity: 0% Activity: 0% Activity: 0%
 
Join Date: Aug 2012
Posts: 1
Thanks: 0
Thanked 0 Times in 0 Posts
Default Select -Statement using 2 tables

i have 2 tables apple a and banana b

if a.pineapple= "p" then display "a.first_name" and 'a.last_name"
if a.pineapple = "O" then display "b.code"

can any one hlp me to write the selct statements