Hi Jeremy,
It sounds like what you're saying is that you have data in Table A, and
you also have data in Table B, but you want one of the fields in Table B
to really be from a field in Table A at all times (transparently). Is
that right?
You could create a VIEW using the CREATE VIEW command
I'm trying to do some more advanced things in sql to make my tables more
efficient. I'd like to do a link, or perhaps it's a join, although
everything I've looked at relating to a join makes me think that it's not
what I'm looking for.
What I would like to do is have a field in a table