I attended one interview, where they asked regarding joining, i answered, generally we join two table at Database layer.
me:DB layer(joining tables),
Business layer(done all the requirements as per client),
presentation layer(short cuts of all items in Business layer)
interviewer:suppose only two tables tab1, tab2. you joined two tables at Db layer as inner join. published the package. again requirement came where we need to give outer join, then where should be updated.
me: in this situation i will join two table at business layer with outer join.
interview: they didnot accept my response, and said then what about inner join.
me: ok, i will create one more business layer.
interviewer: how many business layer you will create , if 10s of requirements are there, you will create that many layers.
me: i said, yes, then nothing said. they said to me only two tables are there, think ;;;;
So i want to know , actually where we need to give the joining ,, tell me guys.. it's irritating to me .. what should be the answer.