Multiple tables? - Tools JX

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 Year, 6 Months 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? Enter code here Please note: although no board code and smiley buttons are shown, they are still usable.

dmaislin

Fresh Boarder

Posts: 4

#650

Re:Multiple tables? 1 Year, 6 Months 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: 181

#653

Re:Multiple tables? 1 Year, 6 Months 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. Enter code here Please note: although no board code and smiley buttons are shown, they are still usable.

dmaislin

Fresh Boarder

Posts: 4

#673

Re:Multiple tables? 1 Year, 6 Months ago	Karma: 0
Please, how can we do this? also, please give step by step instructions. Enter code here Please note: although no board code and smiley buttons are shown, they are still usable.

shinigami

Fresh Boarder

Posts: 4

Page: 1

Moderators: tomaz