I have 3 tables
Table 1: user(id, name, surname)
Table 2: crime(id, detail)
Table 3: user_crime(id, user_id, crime_id)
Table 1
1, OKAN, ARI
Table 2
1, "detail 1"
2, "Detail 2"
Table 3
1, 1, 1
1, 1, 2
So user 1 takes 2 crime from crime table...
I want to receive info with 1 query: I need name surname and his crime_ids
of user_id 1
So result might be:
user_id, name, suername, crime_ids
1, OKAN, ARI, {1-2}
Is it possible?
gibi....
Mumkun mu?
-----------------------------------------------------
Iletisim teknolojilerinin gucunu ispatlayan iletisim teknolojileri dergisi:
Tele.com.tr
http://www.tele.com.tr
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]