but here in my case the table A is joined with the primary key 'id' of table B
In this case, table A may have many instances of table B right, provided
there is a foreign key relation between table A and B on the id column of table B. It holds good that table B is on the many side and table A is on the one side. Your xml syntax seems to be correct for what you require.
Just read a bit on Foreign Keys and you may get a clear picture!
[ May 25, 2007: Message edited by: Raghavan Muthu ]