I tweaked a little and found out the exact query i was looking for , thank you for your help pal, here is the query for future out fellas:
SELECT sid AS allusername,
spass AS allpassword
FROM student
UNION
SELECT fid AS allusername,
fpass AS allpassword
FROM faculty