Answer Posted / nitin

for SET operators the resultant column set should be same for the tables.
i.e.
select * from boy
union
select * from girl
will give an error if they have different column
but in join you can corellete the column to each other.

select * from boy,girl where boy.id_gender=girl.id_gender;

will give result

What is the use of function in sql?

1149

---

How to pipe multiline string to isql?

1049

---

how many groups of data types? : Sql dba

1075

---

Explain the the update statement in sql?

1102

---

Is sql free?

1024

---

How does an execution block start and end in pl sql?

997

---

If i can use sys.check_constraints to display my constraints from my database using sql server 2005, how can i display then if i am using sql server 2000????

4058

---

how to convert numeric values to character strings? : Sql dba

1156

---

Do foreign keys improve performance?

1068

---

How to fix oracle error ora-00942: table or view does not exist

1083

---

Can you upgrade sql express to full sql?

1141

---

Is it possible to link two groups inside a cross products after the cross products group has been created?

1069

---

Which sql statement is used to return only different values?

1054

---

what is a control file ? : Sql dba

1089

---

what are the other commands to know the structure of table using mysql commands except explain command? : Sql dba

1115

---