Select ca.name, ora.ordid, Ora.Orderdate From customer ca, ord Ora Where

9. Display the client name and order date for all orders
using the JOIN . . . USING method.

Question Posted / devraj

Answer Posted / devraj

Select ca.name, ora.ordid, Ora.Orderdate From customer ca,
ord Ora Where Ora.Custid = ca.custid;

Is This Answer Correct ?

0 Yes

0 No

Please Help Members By Posting Answers For Below Questions

Illustrate how to determine the amount of physical CPUs a Unix Box possesses (LINUX and/or Solaris).

2283

What is a table index in oracle?

1091

What is a trigger and what are its types?

1156

What is the sql query to concatenate column values from multiple rows in oracle?

1018

Explain the use of control file?

1079

How to change system global area (sga) in oracle?

981

What do you mean by merge in oracle and how can we merge two tables?

1018

Please explain oracle data types with examples?

1023

How to best split csv strings in oracle 9i?

1007

What do the 9i dbms_standard.sql_txt() and dbms_standard.sql_text() procedures do?

4493

how do u setup a replication site?

1950

What is difference between cartesian join and cross join?

1047

What is the difference between a primary key & a unique key?

1059

what is IDE,DMV in sql server?

2775

What is a cursor and what are the steps need to be taken?

1155