Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. ImperialSardaukar

    I'm a newbie in SQL and I need some basic help please.

    It was IIF and it worked, thanks for everything!
  2. ImperialSardaukar

    I'm a newbie in SQL and I need some basic help please.

    Works like a charm. One last thing... I have the Books table and the column price and boolean column IsForFinalExams and I need to make a query that will decrease 20% of the book Price if IsForFinalExams = True otherwise decreases 10% , any idea? Thanks.
  3. ImperialSardaukar

    I'm a newbie in SQL and I need some basic help please.

    Thanks, works great, although I got another solution with SELECT DISTINCT subject FROM subjects WHERE subject_code Not In ( SELECT subject_code FROM books ); Yours is alot more efficient. I got another question - In the Books table there is a price column, I need to check out the average (I...
  4. ImperialSardaukar

    I'm a newbie in SQL and I need some basic help please.

    I have two tables - books and subjects, they are connected using subject_code, and I need to check which subject does not have any book, how can I do that, can anyone help ?

Part and Inventory Search

Back
Top