Category Archives: sql

ASCII SQL Joins

Posted on February 13, 2009 by Jianming Li

INNER JOIN *Returns all rows from both tables where there is a match *Example SELECT field1, field2, field3 FROM first_table INNER JOIN second_table ON first_table.keyf = second_table.foreign_key RIGHT OUTER JOIN (ASCII and Oracle 9i) *All rows from the left table … Continue reading →

Posted in oracle, sql | Leave a comment