[mbabaali]

 select ename ,age
from emp.e,works(w)
where e.eid=w.eid and (w.did or w.did)

the code is not working out what could be the problem?thanks

[baavgai]

This doesn't look like sql

This is closer.

select e.name, age
   from emp e, works w
   where e.eid=w.eid 

Sorry, no idea what "(w.did or w.did)" could possibly mean. You need a condition for boolean resolution, e.g. "w.did=1". In any case, if w.did was actually a boolean somehow, the statement would alway be true.

I'd recommend writing some queries against the database before using them in PHP. That way, you'll get some debug feedback.

This post has been edited by baavgai: 03 December 2008 - 05:39 AM

[vipulpatel]

please remove . in table alias and remove () in table alias. Use . at comparision time