How to join dell and sony? TableName1: dell
SELECT a1.model,a1.rating, COUNT(a2.rate) ModelRank
FROM dellfeedback a1, dellfeedback a2
WHERE a1.commands like '%light%' and (a1.rating!='poor' and a1.rating!='Not Poor' and (a1.rate <= a2.rate or (a1.rate=a2.rate and a1.model = a2.model)))
GROUP BY a1.model, a1.rating
ORDER BY ModelRank DESC
TableName2: Sony
SELECT a1.model,a1.rating, COUNT(a2.rate) Sales_Rank
FROM Sonyfeedback a1, Sonyfeedback a2
WHERE a1.rating!='poor' and a1.rating!='Not Poor' and(a1.rate <= a2.rate or (a1.rate=a2.rate and a1.model = a2.model) )
GROUP BY a1.model, a1.rating
ORDER BY Sales_Rank DESC
any one tell me here attach my Source
gowthaman8870226416