select a.id, status1, detail
from history a, statusText b
where a.id = b.id;
rob anderson wrote:
> I am new to MySQL so don't laugh!
>
>
> I have a table 2 fields that relate to another table (that stores the
> description)
>
> i.e
>
> history
> id
> status1
> status2
>
>
> statusText
> id
> details
>
>
>
> How can I join the history.status1 and history.status2 fields to the
> statusText table? in order that I can display
>
> id status1Text status2Text
>
>
> Many thanks
>
>
> Rob
>
>
>
> ---------------------------------------------------------------------
> 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
>
>
>
---------------------------------------------------------------------
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
