Hi
I am having 2 tables with different columns .
Employee with columns eid,ename,sal and
product with columns pid,pname,pdesc .My problem is i want to get the count of eid and pid as a single column without common column in tables.Is this possible if Possible help me out
ex: Count of eid=4 and count of pid=9
select Count(eid) from Employee=4
select Count(pid) from product=9
o/p
count of eid and pid=13 is my desired result
vijaya