if i have a Customer table with following datacust id custname1 A2 Band cars table with following datacar id cust id Model1 1 Toyota2 1 Honda3 2 Suzukiwhat is the query to give follwing out putcustid cust name model model 11 A Toyota Honda2 ...

pravintule

 Profile Answers by pravintule Questions by pravintule

• May 28th, 2010

Select c.custid,c.custname,m1.model,m2.model as model1 from customer c1,car m1,car m2where c.custid=distinct(m1.custid) and            c.custid(+)=m2.custid

vinayak1234

 Profile Answers by vinayak1234 Questions by vinayak1234

• Mar 30th, 2010

SELECT c.custid, c.custname, m.model FROM custtable AS c JOIN carstable AS m ON c.custid = m.custidgroup BY c.custid, c.custname, m.model

Answer Question  Select Best Answer