Posted by marc guillaume on 10/25/05 04:27

Le Thu, 20 Oct 2005 02:42:21 +1000, anonymous a écrit :

>
> All i need to do is switch the name and style number values in colums "name, style"
> in the first table for the "data"
> column in the second table. Based on the Index in the second table.
>
> So if name column's value was 23, when i do my select query it would retun "qwer"
> instead of 23
>
> Can ANYONE please help please?

You know there are pretty good tutorials for begginners in SQL on the web...

Try that :

SELECT name, index, data FROM table1 LEFT OUTER JOIN table2 ON name=index
WHERE name='value you want'

• Next in forum: Re: program to query Mysql db which supports graphs?
• Prev in forum: union in from clause
• Thread view: Re: REPOST: HELP! MySQL JOIN - Which one do i use?

[Reply to this message]