SQL_For_Me

SQL For Me Get Values from Multple Tables SELECT table1.column1, table2.column2 FROM table1, table2, table3 WHERE table1.column1 = table2.column1 AND table1.column1 = table3.column1; select dep.dep_id,emp.emp_id,salary.salary from dep,emp,salary where dep.dep_id=emp.dep_id and emp.emp_id=salary.sal_id CASE A special scalar expression in SQL language is CASE expression. SQL CASE expression is used as a kind of IF-THEN-ELSE statement. It is similar to switch statement in modern programming language… More information...

User:	Jayaramchandran Manickam
Page:	saicodes.webnode.com (?)