Answer / vj

Join:It is the combining of two rows from different tables
based on the comparative values in selected columns.

Types of Join : Cross Join, Inner Join or equi join and
Outer Join which comprises of Left join and Right join.

Inner Join : It is used to select certain fields from both
tables and only correct rows will be joined together.
Sytax:SELECT <column_name> FROM <Table1>, <Table2> WHERE
(Table1.column = Table2.column)

Outer Join:
Left join: It returns all the data's from the table
present in left of the join and only those data's from the
right tabel which matches the condition.
Syntax:SELECT <column_name> FROM <Table1> LEFT JOIN
<Table2> ON Table1.column = Table2.column (Conditions like
WHERE and USING)

Right join: It returns all the data's from the table
present in right of the join and only those data's from the
left tabel which matches the condition.
Syntax:SELECT <column_name> FROM <Table1> LEFT JOIN
<Table2> ON Table1.column = Table2.column (Conditions like
WHERE and USING)

we compile any program bu c:/>javac prog.java and run as c:/>java prog Here what's the meaning of c in javac. We have java Interpreter but not compiler.Then why we have to use javac. Please answer this question?

2 Answers  

---

I am trying to pass the string firstName from a Servlet called SampleServet. I am running this on eclipse and it tells me that "the value for annotation attribute must be a constant expression. I don't understand why it is giving me this error. @PersonAnnotation(name = SampleServlet.firstName) public class AnnotationClass{

0 Answers  

---

For printing a message we use System.out.println in normal programs. We use String msg="text....."; Can't we use String msg=" " in normal programs and System.out.println("........") in applets. Please answer this question?

0 Answers  

---

Design a program using one-dimensional array that determines the highest value among the eight input values from a user. Display the difference of each value from the highest to the lowest.

1 Answers   RoboSoft,

---

what are the other loops except for for,while,do while and until?

0 Answers   Aricent,

---

---

Program to print map of India in java.

2 Answers  

---

how to store and retrive a set of values without using an array

8 Answers   FCS, HCL, Maximus,

---

Why the program getting error if we don't use String args[] in main(), even in the case of not getting any arguments from command line?

1 Answers  

---

Can we run Applet in Web browser with security policy files

0 Answers  

---

Is there any static classes are in java give some examples

0 Answers  

---

write a c program which takes 20 numbers in an array as input from user and rearrange them in two different array defining even or odd

0 Answers  

---

Write a java program to display multiplication table in a Frame.

1 Answers  

---