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

What happens to indexes if you drop a table?

1163

How oracle handles dead locks?

1064

Explain the use of record option in exp command.

995

How to specify default values in insert statement using oracle?

1095

What is meant by joins?

1054

Explain an extent?

1091

What is format trigger?

2062

What is bind variable in oracle 11g?

1033

How to fetch the row which has the max value for a column?

994

How to create a table interactively?

1078

Can you create a synonym without having a table?

1034

How to sort the query output in oracle?

1021

How to use windows user to connect to the server?

985

How does the on-delete-cascade statement work?

1098

How to get last row id?

981