Multiple tables?

Welcome, Guest
Please Login or Register. Lost Password?

Multiple tables?

(1 viewing) (1) Guest

This is the optional Forum header for the Suggestion Box.

Page: 1

TOPIC: Multiple tables?

Forum Tools

#644

Multiple tables? 1 Month, 3 Weeks ago	Karma: 0
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?

dmaislin

Fresh Boarder

Posts: 4

The administrator has disabled public write access.

#650

Re:Multiple tables? 1 Month, 3 Weeks ago Karma: 1

Hi,

try this:

e.g. in phpMyAdmin

Code:



CREATE VIEW Something AS

SELECT st.TypeDesc, s.LongDesc

FROM  va_support_types st, va_support s

WHERE  st.Code=s.Code

You can display view with TableJX.

Best regards,
Viljem

viljem

Admin

Posts: 152

The administrator has disabled public write access.

#653

Re:Multiple tables? 1 Month, 3 Weeks ago	Karma: 0
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.

dmaislin

Fresh Boarder

Posts: 4

The administrator has disabled public write access.

#673

Re:Multiple tables? 1 Month, 1 Week ago	Karma: 0
Please, how can we do this? also, please give step by step instructions.

shinigami

Fresh Boarder

Posts: 4

The administrator has disabled public write access.

Page: 1