![]() |
|
|
|
| ||||||
|
Welcome to the The ProgrammersTalk Community forums. You are currently viewing our boards as a guest which gives you limited access to view most discussions and access our other features. By joining our free community you will have access to post topics, communicate privately with other members (PM), respond to polls, upload content and access many other special features. Registration is fast, simple and absolutely free so please, join our community today! If you have any problems with the registration process or your account login, please contact contact us. |
| Tags: |
![]() |
![]() | | LinkBack | Thread Tools | Display Modes | ![]() |
| |
| |||
| Adding a table and Joining tables are different. When you want to join a table to other table, you can use the WHERE clause. Example: SELECT a.name, b.grade FROM table1 a, table2 b WHERE a.studInfo = b.studInfo; *Base from my example above, I joined tables "table1" (a) and "table2" (b) When you want to add a table... CREATE TABLE tableName(Sample1 Varchar2(15), Sample2 char(3)); Add the PEOPLE table and THINGS table CREATE TABLE People (Name Varchar2(20), Gender Char(1)); CREATE TABLE Things (ProdName Varchar2(20), ProdNum Varchar2(20)); COMMIT; |
![]() |
| Thread Tools | |
| Display Modes | |
| |