SQL> no rows selected

[Farakh khan]

Hello,

select 
	unique(c.cv_id),b.name,cvDate,country,nationality,c.status,cvSource,cvName 
from 
	countries a, users b, cvProperties c, cvDetails d, 
	cvSpecialty e, Specialty f
where 
	a.country_id=b.country_id and b.user_id=c.user_id and c.cv_id=d.cv_id
and 
	c.cv_id=e.cv_id and e.specialty_id=f.specialty_id 
and 
	c.cat_id=2;

Above query works fine because record exists in each table row but when I add:

	, cvCertification g, Certification h
---
	and c.cv_id=g.cv_id and g.cert_id=h.cert_id
--

Then it displays "no rows selected" as this table don't have any record for linked cv_id

How can I ignore the table if no record exists to display the rest of records?

Thanks in anticipation

[Farakh khan]

still waiting for reply

[sachin potu]

if i am not wrong , you must use Left join, instead of Equi join

[Farakh khan]

thanks sachin