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 are the execution control statements?
How to define an anonymous block?
What is java oracle used for?
which sql command we can use to get a print out from oracle?
What is sequence?
how to find the n'th highest salary from emp ?
How to create a single index for multiple columns?
diff between DELETE and TRUNCATE?.
14 Answers HCL, Yalamanchili Software,
What is the difference between a primary key & a unique key?
How to open and close an explicit cursor in oracle?
What is truncate oracle?
How do I escape a reserved word in oracle?