select c.name,o.ordid,o.orddate from customer c join oreder o using(custid

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

Question Posted / anjum

Answer Posted / anjum

select c.name,o.ordid,o.orddate from customer c join oreder o
using(custid);

Is This Answer Correct ?

0 Yes

0 No

Please Help Members By Posting Answers For Below Questions

How can we view last record added to a table?

972

Hi Can any one tell me what are the API's used in requisition import.

1880

How to assign values to data fields in record variables?

975

What are privileges and grants?

1002

How to list all user accounts in oracle?

981

Please send me Informatica 8.1 certification dumps, my mail id mona85gupta@gmail.com

1810

Explain what are the characteristics of data files?

1031

When do I need to use a semicolon vs a slash in oracle sql?

1028

What is Virtual Private Database in Oracle?

1017

What is connection pool in oracle?

930

Query to retrieve record for a many to many relationship ?

2460

What is oracle server autotrace in oracle?

1091

What is the max number of columns in an oracle table?

932

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

1118

What is the difference between the Oracle ODBC driver and a Microsoft ODBC (Open Database Connectivity) Driver?

1034