9. Display the client name and order date for all orders
using the JOIN . . . USING method.
Answers were Sorted based on User's Feedback
Answer / 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 |
Answer / anjum
select c.name,o.ordid,o.orddate from customer c join oreder o
using(custid);
| Is This Answer Correct ? | 0 Yes | 0 No |
What is a directory object?
How to get a list of all background sessions in the database?
what is Table ?
What is the order of defining local variables and sub procedures/functions?
How to connect to the server with user account: sys?
Explain a private synonyms?
what is candidate key & super key
How to start a new transaction in oracle?
What is an oracle transaction?
What does `(+)` do in a where clause?
What is a sub query? Describe its types?
What are the general rules on data consistency?