reset password
Author Message
304374842
Posts: 56
Posted 15:56 Jan 23, 2015 |

Hey,

Has anyone done the searched case statement for number 6 on Tarik's homework.  I get how to do a searched case statement and a join, but I am not sure how to do a searched case statement with a join

Any ideas?

Elizabeth

tbooker
Posts: 20
Posted 16:44 Jan 23, 2015 |

Hint: Joins are always performed in FROM clauses.

As an aside:  No one should post code examples or fragments on the Forum.  Experiment on your own how to solve this problem.

Vrezh
Posts: 1
Posted 16:11 Jan 24, 2015 |

I am having the same problem. Everything I try does not work!

304374842
Posts: 56
Posted 09:46 Jan 25, 2015 |

Have you figured anything out yet?  I am really confused.

tbooker
Posts: 20
Posted 18:37 Jan 25, 2015 |

Hint: Make sure you understand how to use comparisons with text.  Review the lab, if you're having trouble.  Do not go too far off the rails with the searched case statement.  I'll be in my office Monday morning at 11:30 for about an hour, if there are questions.

304374842
Posts: 56
Posted 18:38 Jan 25, 2015 |

I have class at 11:30.  Can I come a little earlier?