How about using UNION

>Hello Naomi
>I have three tables each one has a field similar to other as an example.
>table no 1I have a three fields
>1- studentid "0001"
>2- subject " Geography"
>3- teacher name XXXXXX
>4 grade 9
>
>on the second table I have the same things
>studentid 00002
>subject "History"
>teacher name XXXXXX
>grade 9
>on the third
>table no 2 also the same
>Table no 3
>studentid 00002
>subject "Civics"
>teacher name XXXXXX
>grade 11
>
>I am searching in these table to know how many subject for example Mr. X is teaching and what grades,
>Thank you