Multiple tables?

I have two tables:

va_support "Code" "Summary" "Long Description"
va_support_types "Code" "Type Description"

in va_support there is a Code, but I want the Code to display the Type Description from the other table.

Is this possible?

Hi,

try this:

e.g. in phpMyAdmin

CREATE VIEW Something AS
SELECT st.TypeDesc, s.LongDesc
FROM  va_support_types st, va_support s
WHERE  st.Code=s.Code

I do this today. Was hoping you could offer this in your solution, i.e. a window where I could type pure SQL to do the same as well as support selecting multiple tables for LEFT JOIN support, etc.

Please, how can we do this?
also, please give step by step instructions.