i have a typical problem..i have two tables with different fields ..what i require is to search between these two tables and give a a result row wise from each of these two tables.
alternatively can i search for a result throughout the database
table 1 has fields :ser no(auto number) ; name ; date of birth ; place of birth
table 2 has fields ; ser no (auto number) ; name ; place of employment ; date employed on
now amongst these two tables when i search for name in table 1 it should be able to search the name in table 2 also and give results of both . however name cannot be primary key as names can be repeated and it dosent matter if that happens. but i should be able to define parameter search by searchin for values according both the tables field so a specific result may also be achieved.
i hope i am able to convey my problem.any help will be really appreciated i really cannot figure this out
regards
R
rishi111983 author2/1/2016
still no reply?? admin i really could use some help