For example i have 3 tables (really i have to make it with 6 tables, but...)
So 3 tables:
Table1
uid | name
1 user1
2 user2
3 user3
Table2
id uid c
1 1 50
2 1 23
3 1 42
4 2 23
5 2 303
Table3
id c txt
1 23 'twenty-three'
2 42 'the reason of life'
3 50 '50'
4 303 '303 rulz'
how can i get a recordset constains all records (or records matching a where
exp.) from the Table1 with the c values from the Table2, like this:
uid name cs
-----------------
1 user1 '50 - twenty-three - the reason of life'
2 user2 'twenty-three - 303 rulz'
3 user3 ''
I can make heavy things with mysql, but i'm too small for this :)
thanx: Z
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php