ibatis-user-java mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From xianwinwin <xianwin...@gmail.com>
Subject how to write selectByExample and get info from 2 tables?
Date Fri, 12 Oct 2007 17:10:24 GMT

Hi all,

given the following 2 trivial tables: 
1 - user (user_id, fname, lname)
2 - messages (message_id, user_id,  user_message)

I wonder if it is possible to use selectByExample and get:

user_message, fname, lname 

As you can see, this is a combination of 2 tables. 

Is this doable???, if not, what other alternative exists beside writing the
queries (gee, that will take such a long time)

View this message in context: http://www.nabble.com/how-to-write-selectByExample-and-get-info-from-2-tables--tf4614193.html#a13177049
Sent from the iBATIS - User - Java mailing list archive at Nabble.com.

View raw message