Jump to content

Archived

This topic is now archived and is closed to further replies.

grinel

Mysql querry problem

Recommended Posts

Hey guys

I need a help with a query

I have 2 tables

[b]table 1[/b]
code,description


[b]table 2[/b]
field,field2,code1,code2, field3, etc

code1,code2 in table 2, their descriptions can be found in table 1.

i want a query to show me all the records in table 2, but with the codes description instead of the code itself

The result set must therefore have 2 fields for desription, because code1 will not equal code 2
I am stuck with mysql 3.23....

Thanks in advance

Share this post


Link to post
Share on other sites
[code]SELECT a.field1, a.field2, b.description as descr1, c.description as descr2, a.field3, a.etc FROM table2 a LEFT JOIN table1 b ON b.code=a.code1 LEFT JOIN table1 c ON c.code=a.code2[/code]

Share this post


Link to post
Share on other sites

×

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.