[RESOLVED] Refer to single field in tables (design time)

[Nightwalker83]

Hi,

I know to connect two or more tables at design time I need to use either:

1 to 1
1 to Many
Many to Many

However, what do I use if I just want to refer to one field in a particular table?

Thanks,


Nightwalker

[dee-u]

Can you elaborate, I don't understand what you mean.

[leinad31]

select one_field from your_table

[Nightwalker83]

select one_field from your_table

Was that in response to me or dee-u? I have tried what you suggested in Mysql Workbench 5.2 but it only selects the whole table. I will have to double check will my lecturer tomorrow whether we are suppose to refer to the individual fields or whether he just wants us to refer to the tables.

[TysonLPrice]

Guessing what you mean...

select one_field from your_table where one_field = 'Something Unique'

[Nightwalker83]

This is What I mean! This was what I did about 6 years ago using File Maker Pro. How do I accomplish this using Mysql Workbench?

[TysonLPrice]

However, what do I use if I just want to refer to one field in a particular table?

I'll bite...what table, what column, what value?

[Nightwalker83]

I'll bite...what table, what column, what value?

Well, if you use the diagram in the previous post as an example lets say:

The Clients field in the Episode table retrieving the Client ID from the Clients' Table.

[TysonLPrice]

Pretending there is a Clients field in the episode table….not tested.

Select E.Clients from
Clients C
Join Episodes E on c.ClientID = e.ClientID
Where E.Clients = ‘Something unique’

[Nightwalker83]

Pretending there is a Clients field in the episode table….not tested.

Select E.Clients from
Clients C
Join Episodes E on c.ClientID = e.ClientID
Where E.Clients = ‘Something unique’

Thanks! Although, I need to know if it is possible draw the relationship in the picture using Mysql Workbench? If so how?

Edit:

I asked my lecturer and he said I just need to do the relationships like in the first post! Mysql handles the relationships such as those in the above picture differently to File Maker Pro.