How to search for a data form 5 MySQL table at a time?

[Kadir Razu]

I have a MySQL database nammed 'pstu alumni' and five table inside this DB nammed 'agriculture',' bba','cse','dvm ' and 'fisheries' each table with same field common 'Name' and 'Session'.
Then how can I search for a name from these five table at a time and how to show results?

Please help...

Thanks

[Oralloy]

Kadir,

Try using a Union query, if you want everything to appear in two columns.

Cheers!

[code green]

This is usually done with a JOIN statement.
JOIN USING(Name) or Session

[Kadir Razu]

Thanks a lot for your response...

Can u plz suggest me the queary in details to do the task specified.

Thanks...

[code green]

You haven't specified a task, you have asked how to query five tables.
I think you need to make an attempt yourself then come back with any specific problems

[Kadir Razu]

I want to search these tabe at a time for a name e.g 'Shoham'.
If match found (e.g. Name='Shoham'), then details information of that person (Shoham) need to print in another page from raw of the table where match found.

Note : I am using php

[Oralloy]

SELECT Name, Session FROM Table1
UNION
SELECT Name, Session FROM Table2

Try looking here for documentation on the SELECT UNION.

[Kadir Razu]

Thanks "Oralloy" For Your Valuable Response...

That technique works !

Thanks a lot...