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

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

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

select one_field from your_table

Quote:

---

Originally Posted by leinad31

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.

Guessing what you mean...

select one_field from your_table where one_field = 'Something Unique'

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?

Quote:

---

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?

Quote:

---

Originally Posted by TysonLPrice

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.

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’

Quote:

---

Originally Posted by 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’

---

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.